-
-
Notifications
You must be signed in to change notification settings - Fork 1.4k
Closed
@npiguet
Description
Failing SQL Feature:
I'm not sure exactly which SQL feature is causing this issue. Individually, CTEs, INNER JOIN, SELECT, functions etc... have worked fine in all other cases. However, for some reason, this one crashes with:
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "." "."
at line 4, column 28.
Was expecting one of:
<EOF>
<ST_SEMICOLON>
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:53111) ~[jsqlparser-5.3.jar:?]
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:52929) ~[jsqlparser-5.3.jar:?]
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:436) ~[jsqlparser-5.3.jar:?]
at net.sf.jsqlparser.parser.CCJSqlParserUtil1ドル.call(CCJSqlParserUtil.java:341) ~[jsqlparser-5.3.jar:?]
at net.sf.jsqlparser.parser.CCJSqlParserUtil1ドル.call(CCJSqlParserUtil.java:338) ~[jsqlparser-5.3.jar:?]
at java.base/java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:317) ~[?:?]
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java) ~[?:?]
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
at java.base/java.lang.Thread.run(Thread.java:1583) ~[?:?]
SQL Example:
WITH values AS (SELECT unnest(?) as vals) SELECT encode(value_hash::bytea, 'hex') AS value, id FROM fact_values INNER JOIN values ON values.vals = encode(value_hash::bytea, 'hex')
Software Information:
- JSqlParser version 5.3
- Database: PostgreSQL
Metadata
Metadata
Assignees
Labels
No labels