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

IntelliSense in SQL notebook or T-SQL editor shows pgsql snippets... #7682

Open uc-msft opened 4 years ago

uc-msft commented 4 years ago

Issue Type: Bug

Subject says it all.

Azure Data Studio version: azuredatastudio-insiders 1.12.0-insider (93c9426f25e632e8e3dd6e572d48d559ae07a7bf, 2019-10-10T18:18:16.586Z) OS version: Windows_NT x64 10.0.18999

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-7820HQ CPU @ 2.90GHz (8 x 2904)| |GPU Status|2d_canvas: enabled
flash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
native_gpu_memory_buffers: disabled_software
oop_rasterization: disabled_off
protected_video_decode: enabled
rasterization: enabled
skia_deferred_display_list: disabled_off
skia_renderer: disabled_off
surface_synchronization: enabled_on
video_decode: enabled
viz_display_compositor: disabled_off
webgl: enabled
webgl2: enabled| |Load (avg)|undefined| |Memory (System)|31.85GB (15.48GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (8) Extension|Author (truncated)|Version ---|---|--- ssmskeymap|kev|1.1.0 admin-tool-ext-win|Mic|0.0.2 agent|Mic|0.43.0 azuredatastudio-postgresql|Mic|0.2.2 dacpac|Mic|0.7.0 import|Mic|0.11.0 profiler|Mic|0.10.0 sql-vnext|Mic|0.16.0
kevcunnane commented 4 years ago

Hi UC - if you have the postgresql extension installed then snippets installed by that extension are available in any SQL editor, since they're not interactive / dynamic. I'd suggest closing this as "by design".

uc-msft commented 4 years ago

Why can't we differentiate the snippets based on the extension or connection context. I can differentiate between SQL & PgSQL syntax but new users learning the databases won't be able to. So they will try a snippet & have it fail.