dt-sql-parser icon indicating copy to clipboard operation
dt-sql-parser copied to clipboard

[Bug]: The Trino parser seems to be broken

Open s-ajith-kumar opened this issue 1 year ago • 3 comments

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

s-ajith-kumar avatar Feb 26 '24 11:02 s-ajith-kumar

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

LuckyFBB avatar Mar 07 '24 08:03 LuckyFBB

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

image

s-ajith-kumar avatar May 06 '24 01:05 s-ajith-kumar

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

LuckyFBB avatar Jun 14 '24 06:06 LuckyFBB

Close because inactive

HaydenOrz avatar Sep 09 '24 03:09 HaydenOrz