Justin Swett created CALCITE-4297: ------------------------------------- Summary: Babel should accept CURRENT_DATE and CURRENT_DATETIME Key: CALCITE-4297 URL: https://issues.apache.org/jira/browse/CALCITE-4297 Project: Calcite Issue Type: Bug Components: babel Affects Versions: 1.25.0 Reporter: Justin Swett
The following BigQuery sql should be accept CURRENT_DATE and CURRENT_DATETIME with and without parens. (CURRENT_TIME and CURRENT_TIMESTAMP should also accept parens) 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. {code:java} 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 {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)