[BUG] JSQLParser Version : Postgres : BETWEEN with Cast

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

I'm happy to put a PR together, but I'm struggling to work out what I need to change in https://github.com/davyboyhayes/JSqlParser/blob/95ebda5a6112cd79811a63c69ae05be2a8aedc7a/src/main/jjtree/net/sf/jsqlparser/parser/JSqlParserCC.jjt#L5749-L5762

Greetings!

I believe the LOOKAHEADS need to be changed into Semantic Lookaheads, e.g.:

LOOKAHEAD(  ParenthesedSelect()  ) betweenExpressionStart = ParenthesedSelect()
|
LOOKAHEAD( RegularCondition() ) betweenExpressionStart = 
|
betweenExpressionStart  = SimpleExpression()

I will fix that tomorrow since I have another case I have to work on.

I've raised #2289. Feel free to ignore it if you have more to build on, but your suggestion results in a passing test for that SQL, thanks!

Navigation Menu

Repository navigation

[BUG] JSQLParser Version : Postgres : BETWEEN with Cast #2288

Failing SQL Feature:

SQL Example:

Software Information:

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

[BUG] JSQLParser Version : Postgres : BETWEEN with Cast #2288

Description

Failing SQL Feature:

SQL Example:

Software Information:

Activity

davyboyhayes commented on Aug 5, 2025

manticore-projects commented on Aug 5, 2025

manticore-projects commented on Aug 5, 2025

davyboyhayes commented on Aug 5, 2025

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions