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.57k stars 900 forks source link

Intellisense incorrectly identifies errors in a query using the SQL Server $PARTITION function #15222

Open gbritton1 opened 3 years ago

gbritton1 commented 3 years ago

Intellisense incorrectly identifies errors in a query using the SQL Server $PARTITION function

Steps to Reproduce:

In a database with a valid partition scheme and function defined, enter the query

Select $partition.<partition function>(<partition function parameter>)

red squiggles appear under the period and the function parameter

Error messages:

Incorrect syntax near '.'. Incorrect syntax near '42'. Expecting '(', or SELECT.

gbritton1 commented 3 years ago

Please send to language service team