search

DTStack / dt-sql-parser

SQL Parsers for BigData, built with antlr4.
https://dtstack.github.io/monaco-sql-languages/
MIT License
273 stars 90 forks source link

[Bug]: The Trino parser seems to be broken #266

Open s-ajith-kumar opened 4 months ago

s-ajith-kumar commented 4 months ago

Version

4.0.0-beta.4.11

Which SQL?

Trino

SQL content

select * from whatever limit 100;

JavaScript/TypeScript code

No response

What happened?

The Trino parser doesn't seem to be working for the limit query mentioned above. 100 is being excluded by the parser

For "select from whatever limit 100;", the parser (splitSQLByStatement) returns "select from whatever limit"

Relevant log output

No response

LuckyFBB commented 3 months ago

I tried to reproduce the issue locally and found no problem. Just because there are too many parsed nodes, 100 has not been displayed on the screen. You can see the node by scrolling the current screen. Please check this gif. 1

s-ajith-kumar commented 1 month ago

Opening this again. The issue is actually with splitSQLByStatement @LuckyFBB, @mumiao

image

LuckyFBB commented 2 weeks ago

version: 4.0.0-beta.4.11

图片

verison: 4.0.1

图片

yes, this is a bug for version 4.0.0-beta.4.11, and we resolve it at lastest version 4.0.1, please upgrade your sql-parser version