-
-
Notifications
You must be signed in to change notification settings - Fork 1.4k
Open
Assignees
Labels
@johaasen
Description
Failing SQL Feature:
- LIMIT with subquery cannot be parsed, although valid PostgreSQL
- Error discovered during upgrade from JSQLParser 5.2 to 5.3 within a spring-boot / spring-data application
- Online example
- Seems to recognize a limit-by expression, although plain-limit
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token:<EOF>
at line X, column Y.
Was expecting:
"BY"
at app//net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:53111)
at app//net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:52929)
at app//net.sf.jsqlparser.parser.CCJSqlParser.LimitBy(CCJSqlParser.java:16031)
at app//net.sf.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:11805)
at app//net.sf.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:10144)
at app//net.sf.jsqlparser.parser.CCJSqlParser.SelectWithWithItems(CCJSqlParser.java:10108)
at app//net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:503)
at app//net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:413)
SQL Example:
-- self contained / anonymized example WITH some_table AS ( SELECT 1 AS some_column, 2 AS another_column ), another_table AS ( SELECT 'some_value' AS condition_column ) SELECT some_column FROM some_table ORDER BY some_column -- this kind of limit expression is not supported LIMIT (SELECT COUNT(*) FROM another_table WHERE condition_column = 'some_value') -- real world-like rather more complex, should also be supported -- LIMIT GREATEST(0, 100 - (SELECT COUNT(*) FROM another_table WHERE condition_column = 'some_value'))
Software Information:
- JSqlParser version 5.3 / 5.4
- PostgreSQL