sql-metadata icon indicating copy to clipboard operation
sql-metadata copied to clipboard

mssql sql query with top keyword problem

Open truerico opened this issue 3 years ago • 0 comments

Hi,

the library seem to have issue parsing query with the mssql keyword top , whenever you do so the first column is found to be an alias but it's not ,it s a real column.

  • here is a query to reproduce SELECT top 10 id, name FROM foo

  • I tested there https://sql-app.infocruncher.com/

Good reception. image

truerico avatar May 18 '22 19:05 truerico