Uploaded image for project: 'Apache HAWQ'
  1. Apache HAWQ
  2. HAWQ-1532

Recognize CST incorrectly when quey timestamp with time zone in China

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3.0.0-incubating
    • Component/s: Core
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                rlei Radar Lei
                Reporter:
                kuien Kuien Liu
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: