Incorrect Results

[kfordaccela]

Type: Bug

Results are incorrect until I go to another tab and come back. I think that it has something to do with handling the cache in the results.

Query uses outer apply to return results.

Result before going to another tab and back:

Result after going to another tab and back:

Azure Data Studio version: azuredatastudio 1.49.1 (2f696aa, 2024-08-13T18:12:38.831Z)
OS version: Windows_NT x64 10.0.22631
Restricted Mode: No
Preview Features: Enabled
Modes:

System Info

Item	Value
CPUs	12th Gen Intel(R) Core(TM) i7-12800H (20 x 2803)
GPU Status	2d_canvas: enabled canvas_oop_rasterization: enabled_on direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: enabled
Load (avg)	undefined
Memory (System)	31.68GB (13.38GB free)
Process Argv
Screen Reader	no
VM	0%

Extensions (13)

Extension	Author (truncated)	Version
admin-pack	Mic	0.0.2
admin-tool-ext-win	Mic	0.1.3
agent	Mic	0.49.0
azuredatastudio-oracle	Mic	0.1.6
dacpac	Mic	1.14.0
dsct-oracle-to-ms-sql	Mic	1.1.0
import	Mic	1.6.1
net-6-runtime	Mic	1.1.0
profiler	Mic	0.14.0
query-history	Mic	0.5.3
schema-compare	Mic	1.21.0
sql-database-projects	Mic	1.4.3
whoisactive	Mic	0.1.5