[BUG] JSQLParser Version : SQL syntax is correct, but parsing failed in 5.1-SNAPSHOT version

JSQLParser / JSqlParser

JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern

https://github.com/JSQLParser/JSqlParser/wiki

Apache License 2.0

5.34k stars 1.34k forks source link

[BUG] JSQLParser Version : SQL syntax is correct, but parsing failed in 5.1-SNAPSHOT version #2086

Closed shenshihala closed 3 hours ago

shenshihala commented 3 hours ago

Failing SQL Feature:

SQL syntax is correct, but parsing failed
example url

SQL Example:

select id,description,sample from stu_info_template sit where sit.`type` = 1 and sit.del_flag = '0' order by edu_category,id

Software Information:

JSqlParser version 5.1-SNAPSHOT
Mysql 8.0

manticore-projects commented 3 hours ago

Greetings!

SAMPLE is a reserved keyword and needs to be quoted. See https://manticore-projects.com/JSQLParser/keywords.html