search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.5k stars 882 forks source link

Incorrect squiggles in query after rename #25626

Open deej79 opened 1 month ago

deej79 commented 1 month ago

Type: Bug

Create a query using the automatic "SELECT TOP 1000" from the context menu. Right click on either the table name or a column name in the database explorer window, and rename the object. Edit the open script to reflect the renamed table or column. Red squiggle(s) say(s) object not found, but the script will successfully run. Refreshing the database list does not help.

Azure Data Studio version: azuredatastudio 1.48.0 (4970733324ef8254b7c22a5dc55af7f8a1dea93f, 2024-02-27T00:05:08.293Z) OS version: Windows_NT x64 10.0.19045 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|Intel(R) Xeon(R) CPU E3-1230 v5 @ 3.40GHz (8 x 3408)| |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)|15.92GB (7.32GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (14) Extension|Author (truncated)|Version ---|---|--- newdatabase|kev|1.0.0 admin-pack|Mic|0.0.2 admin-tool-ext-win|Mic|0.1.3 agent|Mic|0.49.0 import|Mic|1.6.1 powershell|ms-|2022.7.2 profiler|Mic|0.14.0 query-history|Mic|0.5.3 schema-compare|Mic|1.21.0 sql-database-projects|Mic|1.4.2 schema-visualization|R0t|0.9.1 db-snapshot-creator|sea|0.1.0 simple-data-scripter|sea|0.1.6 vscodeintellicode|Vis|1.2.1
deej79 commented 1 month ago

Additional info. Closing the tab and recreating it may work. However, I renamed a table from XXX to YYY, and then created a new table XXX. New queries showed the squiggles, indicating the "errors" are cached somewhere in the app. Only closing ADS and reopening it full cleared the problem.