[BUG] JSQLParser Version : Postgres : BETWEEN with Cast #2288
Description
Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram
Failing SQL Feature:
- Using a
betweenexpression, withcastdoesn'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