Repository navigation

[BUG] JSQLParser 5.3: RDBMS Oracle: failing to parse oracle BETWEEEN #2287

Closed

opened

Failing SQL Feature:

The following statement using BETWEEN AND TO_CHAR/ADD_MONTHS cannot be parsed
Example: BETWEEN using to_char and add_months can't be parsed

SQL Example:

Query Example

SELECT
    DUMMY
FROM
    dual
WHERE
    DUMMY BETWEEN to_char(add_months(sysdate, - 2),'YYYYMMDD') AND to_char(sysdate, 'YYYYMMDD')

Software Information:

JSqlParser version 5.3
Database: Oracle DB, any version

mantesap
changed the title ~~[-][BUG] JSQLParser Version : RDBMS : failing to parse oracle BETEEEN[/-]~~ [+][BUG] JSQLParser 5.3: RDBMS Oracle: failing to parse oracle BETEEEN[/+] on Aug 3, 2025
mantesap
changed the title ~~[-][BUG] JSQLParser 5.3: RDBMS Oracle: failing to parse oracle BETEEEN[/-]~~ [+][BUG] JSQLParser 5.3: RDBMS Oracle: failing to parse oracle BETWEEEN[/+] on Aug 3, 2025
davyboyhayes commented on Aug 5, 2025
davyboyhayes
on Aug 5, 2025
Contributor
#2289 should have fixed this (I just checked by adding this SQL to the test suite and it passed)
mantesap commented on Aug 6, 2025
mantesap
on Aug 6, 2025
Author
I can confirm the fix using the latest source
mantesap
closed this as completed on Aug 6, 2025

to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Assignees

No one assigned

Labels

No labels

No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests