Julian Hyde created CALCITE-5601:
------------------------------------

             Summary: Set 'timestamp' and 'timezone' in Quidem test scripts, 
and have datetime functions observe them
                 Key: CALCITE-5601
                 URL: https://issues.apache.org/jira/browse/CALCITE-5601
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde


For testing, it is useful to be able to set the session's timezone and the 
current time via Quidem variables (and perhaps by other means). Datetime 
functions should observe them  - e.g. {{CURRENT_TIMESTAMP}} and 
{{CURRENT_DATE}} will return a value based on {{timestamp}}, and the 
{{TIMESTAMP(string[, timeZone])}} should use the session time zone if the 
timeZone argument is omitted.

See [TODO in 
big-query.iq|https://github.com/apache/calcite/blob/ba975ba0612768c24677a74fbb9bf7a2922bce36/babel/src/test/resources/sql/big-query.iq#L33-L46].



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to