Repository navigation
[BUG] JSQLParser Version 4.5: RDBMS : "Encountered unexpected token: "SELECT" <K_SELECT> at line 11, column 1." #1798
Description
Activity
Greetings!
This has been fixed in PR #1778 which will be released as JSQLParser 5 soonest.
You can try it here.The AST will look like this:
SQL Text └─Statements: statement.select.PlainSelect ├─selectItems: statement.select.SelectItem │ └─Column: c1 ├─selectItems: statement.select.SelectItem │ ├─expression: expression.Function │ │ └─ExpressionList: n │ └─Alias: AS n ├─fromItem: statement.select.ParenthesedSelect │ └─select: statement.select.SetOperationList │ ├─selects: statement.select.ParenthesedSelect │ │ └─select: statement.select.PlainSelect │ │ ├─selectItems: statement.select.SelectItem │ │ │ └─Column: c1 │ │ ├─selectItems: statement.select.SelectItem │ │ │ ├─expression: expression.Function │ │ │ │ └─ExpressionList: n │ │ │ └─Alias: AS n │ │ ├─Table: t1 │ │ └─groupBy: statement.select.GroupByElement │ │ └─ExpressionList: c1 │ ├─selects: statement.select.PlainSelect │ │ ├─selectItems: statement.select.SelectItem │ │ │ └─Column: c1 │ │ ├─selectItems: statement.select.SelectItem │ │ │ ├─LongValue: 0 │ │ │ └─Alias: AS n │ │ └─Table: t2 │ └─UnionOp: UNION ALL └─groupBy: statement.select.GroupByElement └─ExpressionList: c1many thanks! It works
Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram
Failing SQL Feature:
"Encountered unexpected token: "SELECT" <K_SELECT> at line 11, column 1"
SQL Example:
SELECT C1, SUM(N) AS N FROM ( ( SELECT C1, SUM(N) AS N FROM T1 GROUP BY C1 ) UNION ALL SELECT C1, 0 AS N FROM T2 ) GROUP BY C1Software Information:
Tips:
Query is very bad but works on Oracle DB. Line 11 is the "UNION ALL" SQL command.