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)