[BUG] JSQLParser Version 4.8: DB2 : CURRENT TIMEZONE parsing failure

[ashutoshk2206]

Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram

Failing SQL Feature:

SELECT * FROM TABLE1 where COL_WITH_TIMESTAMP <= CURRENT TIMESTAMP - CURRENT TIMEZONE

Above query validation is failing with below error
"Cannot parse statement: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "ZONE" "ZONE"\n at line 1, column 177.\n\nWas expecting one of:\n\n "::"\n "["\n "^"\n \n <ST_SEMICOLON>\n"

Software Information:

• JSqlParser version 4.8
• Database (IBM DB2 )

Tips:

Please write in English and avoid Screenshots (as we can't copy and paste content from it).
Try your example online with the latest JSQLParser and share the link in the error report.
Do provide Links or References to the specific Grammar and Syntax you are trying to use.

[manticore-projects]

Greetings.

CURRENT TIMEZONE is not supported.
I also struggle to understand how the expression CURRENT TIMESTAMP - CURRENT TIMEZONE makes sense, since CURRENT TIMEZONE is not supposed to be a scalar, is it?

[ashutoshk2206]

Its special register as per https://www.ibm.com/docs/en/db2/11.1?topic=registers-current-timezone
But the query works fine in DB2.