Syntax problem for valid INTO clause in IF...ELSE condition #3
Description
Type: Bug
With a query like
IF ...
SELECT ... INTO #temp ...
ELSE
SELECT ... INTO #temp ...
DROP TABLE #temp
the IDE will highlight the second #temp as a problem, saying "There is already an object named '#temp' in the database", where no such table exists.
In my particular query I think can get away with UNION instead of IF...ELSE but that is still valid syntax.
Azure Data Studio version: azuredatastudio 1.44.1 (8f53a316fa00a98264f1ab119641cd540b5af25c, 2023-06-01T02:12:48.765Z)
OS version: Windows_NT x64 10.0.19044
Restricted Mode: No
Preview Features: Disabled
Modes:
System Info
| Item | Value |
|---|---|
| CPUs | 11th Gen Intel(R) Core(TM) i5-1145G7 @ 2.60GHz (8 x 1498) |
| GPU Status | 2d_canvas: enabled canvas_oop_rasterization: disabled_off 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 skia_renderer: enabled_on video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: disabled_off |
| Load (avg) | undefined |
| Memory (System) | 7.73GB (0.85GB free) |
| Process Argv | |
| Screen Reader | no |
| VM | 0% |