Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram
Failing SQL Feature:
- Using a
between expression, with cast doesn't parse correctly
SQL Example:
- Simplified Query Example, focusing on the failing feature
SELECT * FROM tbl WHERE
day BETWEEN
CAST(CAST((NOW() + INTERVAL '-30 day') AS date) AS timestamptz)
AND
CAST(CAST((NOW() + INTERVAL '-1 day') AS date) AS timestamptz);
Software Information:
- JSqlParser 5.4-snapshot 2ff7342
- PostgreSQL
Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram
Failing SQL Feature:
betweenexpression, withcastdoesn't parse correctlySQL Example:
Software Information: