copilot suggestions are seemingly unaware of sql syntax of editor

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

copilot suggestions are seemingly unaware of sql syntax of editor #23276

Open dzsquared opened 1 year ago

dzsquared commented 1 year ago

I have MySQL, PGSQL, Kusto & Oracle extensions installed. Now, if I open new query window (default is set to MSSQL language) & try to use the hint I end up getting PGSQL syntax:

it seems like copilot doesn't know which SQL syntax the current editor is set to

MatthewChapmanMIS commented 1 year ago

copilot is flat out making suggestions to me using tables and columns that don't even exist