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

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 2.3.0.0-incubating
    • Core
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: