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

[mantesap]

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

[davyboyhayes]

#2289 should have fixed this (I just checked by adding this SQL to the test suite and it passed)

[mantesap]

I can confirm the fix using the latest source