GeezerVison is showing github.com — 4.3Release:Error SQL:select database() from dual · Issue #1443 · JSQLParser/JSqlParser
4.3Release:Error SQL:select database() from dual #1443
Description
DB : mysql5.7
JSqlParser : 4.3
public static void main(String[] args) {
String sql = "select database() from dual";
try {
Statement statement = CCJSqlParserUtil.parse(sql);
System.out.println(statement.toString());
} catch (JSQLParserException e) {
throw new RuntimeException(e.getCause() + "Failed to process, Error SQL:" + sql);
}
}
run result:
Exception in thread "main" java.lang.RuntimeException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "database" "DATABASE"
at line 1, column 8.
Was expecting one of:
"*"
"STRAIGHT_JOIN"
Failed to process, Error SQL:select database() from dual
at com.ruoyi.common.Test.main(Test.java:15)
Greetings.
this bug not fixed on release-4.3, but Why does it work normally with 4.3-Snapshot ?
Activity
changed the title
[-]Error SQL:select database() from dual[/-] [+]4.3:Error SQL:select database() from dual[/+] on Dec 13, 2021changed the title
[-]4.3:Error SQL:select database() from dual[/-] [+]4.3Release:Error SQL:select database() from dual[/+] on Dec 13, 2021wumpz commented on Dec 20, 2021
In one of PRs that were never deployed to 4.3-SNAPSHOT there was a construct included using a new keyword "database". That's why in the release this does not work anymore.
select database2() from dual
works.
manticore-projects commented on Dec 30, 2021
Solved by PR #1382 (which properly allows token for certain use.)
Metadata
Metadata
Development
No branches or pull requestsIssue actions