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.53k stars 896 forks source link

red squiggly lines for CREATE DATABASE SCOPED CREDENTIAL #4298

Open jrowlandjones opened 5 years ago

jrowlandjones commented 5 years ago

Issue Type: Bug

CREATE DATABASE SCOPED CREDENTIAL AzureStorageCredential WITH IDENTITY = 'asc', Secret = '';

Red squiggly syntax lines under name of scoped credential AzureStorageCredential and keyword IDENTITY

Azure Data Studio version: azuredatastudio 1.4.5 (887f4e8985023602e599cf86bdb44df48bb28569, 2019-02-12T06:20:08.633Z) OS version: Windows_NT x64 10.0.17763

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-6700 CPU @ 3.40GHz (8 x 3408)| |GPU Status|2d_canvas: enabled
checker_imaging: disabled_off
flash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
native_gpu_memory_buffers: disabled_software
rasterization: enabled
video_decode: enabled
video_encode: enabled
webgl: enabled
webgl2: enabled| |Memory (System)|63.92GB (23.66GB free)| |Process Argv|C:\Program Files\Azure Data Studio\azuredatastudio.exe| |Screen Reader|no| |VM|0%|
Extensions (3) Extension|Author (truncated)|Version ---|---|--- ssmskeymap|kev|1.1.0 sql-dw|Mic|0.0.1 sql-vnext|Mic|0.10.2
jrowlandjones commented 5 years ago

image

kburtram commented 5 years ago

these errors are coming from the SQL Server T-SQL Parser and would need to be fixed upstream in that component.

jasonhorner commented 9 months ago

Can someone look into this again please? For my scenario targeting a Synapse Serverless Sql Pool database project. The underlying project builds successfully with the current version of DacFX. Here is my TSQL: CREATE DATABASE SCOPED CREDENTIAL [WorkspaceIdentity] WITH IDENTITY = N'Managed Identity';

Here is a a screenshot from the latest ADS: image

here is the clean build output: image