[BUG] JSQLParser Version : RDBMS : failing feature description #2422
Description
Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram
Failing SQL Feature:
Extra parentheses leads to a grammar issue in the and expression processing.
The following query processes fine on the DB but fails like below
If your remove the outermost set of parentheses - it then parses fine.
Ran on version 5.3
Caused by: com.snc.shaded.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
at line 2, column 15.
Was expecting one of:
")"
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:53111)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:52929)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:16496)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:16442)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.XorExpression(CCJSqlParser.java:16424)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:16495)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:16442)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.XorExpression(CCJSqlParser.java:16424)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:16495)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:16442)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.XorExpression(CCJSqlParser.java:16424)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:16495)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:16442)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.XorExpression(CCJSqlParser.java:16424)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.SelectItem(CCJSqlParser.java:12527)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.SelectItemsList(CCJSqlParser.java:12437)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.PlainSelect(CCJSqlParser.java:11637)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.Select(CCJSqlParser.java:10144)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.SelectWithWithItems(CCJSqlParser.java:10108)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:503)
at com.snc.shaded.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:413)
SQL Example:
SELECT
((((position('-' IN (
CASE WHEN ((
CASE WHEN (5 < 0) THEN
'yes'
ELSE
'no'
END) = 'yes') THEN
SUBSTRING('2012-january-18', (((LENGTH('2012-january-18')) + (5)) + (1)), ABS((0) - (5)))
ELSE
SUBSTRING('2012-january-18', ((5) + (1)))
END)) - 1) + (1)) - (5)) + (0))
FROM
testtable
Software Information:
- JSqlParser version. 5.3
- Database: postgres