hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kuien Liu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1532) Recognize CST incorrectly when quey timestamp with time zone in China
Date Fri, 29 Sep 2017 10:14:02 GMT
Kuien Liu created HAWQ-1532:
-------------------------------

             Summary: Recognize CST incorrectly when quey timestamp with time zone in China
                 Key: HAWQ-1532
                 URL: https://issues.apache.org/jira/browse/HAWQ-1532
             Project: Apache HAWQ
          Issue Type: Improvement
          Components: Core
            Reporter: Kuien Liu
            Assignee: Radar Lei


On some platforms, CST (China Standard Time) is used as time string suffix of GMT+8, especially
for users in China. Then we suffer from following issue:

postgres=# show log_timezone;
 log_timezone
--------------
 PRC
(1 row)

postgres=# select '2017-09-28 18:26:27.950106 CST'::timestamp with time zone;
          timestamptz
-------------------------------
 2017-09-29 08:26:27.950106+08
(1 row)

And the 'logtime' in view 'hawq_toolkit.hawq_log_master_concise' is not correct as well.




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message