Closed
Description
Search before asking
- I searched the issues and found no similar issues.
What Happened
when parsing sql:"select top 10 a.* from (select datediff(day, '2024-03-01', '2024-04-01') as 日期差多少天) a;"
raise assertionError: “Root variant not successfully parsed.”
Expected Behaviour
plain sql is right, should be no error
Observed Behaviour
assertionError: “Root variant not successfully parsed.” raised
How to reproduce
sql is: select top 10 a.* from (select datediff(day, '2024-03-01', '2024-04-01') as 日期差多少天) a;
Dialect
tsql
Version
python 3.10.14
sqlfluff 3.0.7
Configuration
default
Are you willing to work on and submit a PR to address the issue?
- Yes I am willing to submit a PR!
Code of Conduct
- I agree to follow this project's Code of Conduct