[HAWQ-1532] Recognize CST incorrectly when quey timestamp with time zone in China

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.3.0.0-incubating
• Component/s: Core
• Assignee: Radar Da Lei
• Reporter: Kuien Liu
• Created: 29/Sep/17 10:13
• Updated: 20/Dec/17 02:25
• Resolved: 20/Dec/17 02:25

Description

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.

Issue Links

• links to: GitHub Pull Request #1292