[ https://issues.apache.org/jira/browse/CALCITE-4297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17210227#comment-17210227 ]
Justin Swett edited comment on CALCITE-4297 at 10/8/20, 2:13 PM: ----------------------------------------------------------------- Ok, adding BIG_QUERY to SqlConformanceEnum's allowNiladicParentheses resolves the parens issue. Next I'll look into CURRENT_DATETIME. was (Author: jswett): Ok, adding BIG_QUERY to SqlConformanceEnum's allowNiladicParentheses resolves the parens issue. Next I'll look into CURRENT_DATE, CURRENT_DATETIME. > Babel should accept CURRENT_DATE and CURRENT_DATETIME, with and without > parentheses > ----------------------------------------------------------------------------------- > > 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 > Priority: Major > > 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. > > {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)