[
https://issues.apache.org/jira/browse/FLINK-22349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jark Wu closed FLINK-22349.
---------------------------
Resolution: Fixed
Fixed in
- master: 4be9aff3eccb3808df1f10ef7c30480ec11a9cb0
- release-1.13: 5f666c3731e5c41e06e1cc759fb5c2eb550df6f0
> LOCALTIMESTAMP doesn't return correct result when setting session time zone
> to 'UTC-10:00'
> ------------------------------------------------------------------------------------------
>
> Key: FLINK-22349
> URL: https://issues.apache.org/jira/browse/FLINK-22349
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / API
> Reporter: Jark Wu
> Assignee: Leonard Xu
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.13.0, 1.14.0
>
>
> {code:sql}
> set execution.runtime-mode = batch;
> set sql-client.execution.result-mode = tableau;
> set table.local-time-zone = 'UTC-10:00';
> select
> LOCALTIME,
> CURRENT_DATE,
> LOCALTIMESTAMP,
> CURRENT_TIME,
> CURRENT_TIMESTAMP,
> NOW(),
> CURRENT_ROW_TIMESTAMP(),
> PROCTIME()
> from (values (1), (2), (3), (4), (5)) as T(a);
> +--------------+--------------+-------------------------+--------------+-------------------------+-------------------------+-------------------------+-------------------------+
> | LOCALTIME | CURRENT_DATE | LOCALTIMESTAMP | CURRENT_TIME |
> CURRENT_TIMESTAMP | EXPR$5 | EXPR$6 |
> EXPR$7 |
> +--------------+--------------+-------------------------+--------------+-------------------------+-------------------------+-------------------------+-------------------------+
> | 09:00:58.905 | 2021-04-19 | 2021-04-19 09:00:58.905 | 09:00:58.905 |
> 2021-04-18 23:00:58.905 | 2021-04-18 23:00:58.905 | 2021-04-18 23:00:59.033 |
> 2021-04-18 23:00:59.033 |
> | 09:00:58.905 | 2021-04-19 | 2021-04-19 09:00:58.905 | 09:00:58.905 |
> 2021-04-18 23:00:58.905 | 2021-04-18 23:00:58.905 | 2021-04-18 23:00:59.033 |
> 2021-04-18 23:00:59.033 |
> | 09:00:58.905 | 2021-04-19 | 2021-04-19 09:00:58.905 | 09:00:58.905 |
> 2021-04-18 23:00:58.905 | 2021-04-18 23:00:58.905 | 2021-04-18 23:00:59.033 |
> 2021-04-18 23:00:59.033 |
> | 09:00:58.905 | 2021-04-19 | 2021-04-19 09:00:58.905 | 09:00:58.905 |
> 2021-04-18 23:00:58.905 | 2021-04-18 23:00:58.905 | 2021-04-18 23:00:59.033 |
> 2021-04-18 23:00:59.033 |
> | 09:00:58.905 | 2021-04-19 | 2021-04-19 09:00:58.905 | 09:00:58.905 |
> 2021-04-18 23:00:58.905 | 2021-04-18 23:00:58.905 | 2021-04-18 23:00:59.033 |
> 2021-04-18 23:00:59.033 |
> +--------------+--------------+-------------------------+--------------+-------------------------+-------------------------+-------------------------+-------------------------+
> 5 rows in set
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
