[CALCITE-4297] Babel should accept CURRENT_DATE and CURRENT_DATETIME, with and without parentheses

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.25.0
• Fix Version/s: 1.27.0
• Component/s: babel
• Labels: pull-request-available
• Assignee: Danny Chen
• Reporter: Justin Swett
• Created: 30/Sep/20 16:36
• Updated: 03/Jun/21 22:31
• Resolved: 14/Oct/20 03:58

Description

The following BigQuery SQL contains CURRENT_DATE and CURRENT_DATETIME without parentheses. Babel parser should accept it. (It should also accept CURRENT_TIME and CURRENT_TIMESTAMP with parentheses.)

 

The following SQL should trigger CalciteContextException: No match found for function signature CURRENT_TIMESTAMP() for the date functions, or if you add parens to the current_time.

 

WITH THE_TIMES_ARE_STATIC AS
(SELECT
    CURRENT_DATE as a_date,
    CURRENT_DATETIME() as a_datetime,
    CURRENT_TIME as a_time,
    CURRENT_TIMESTAMP() as a_timestamp
)
SELECT * FROM THE_TIMES_ARE_STATIC 

Issue Links

• links to: GitHub Pull Request #2203