Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4749

mcs247_from_unixtime_funtion fails if local time zone is not GMT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.6.1, 6.1.1
    • 6.1.1
    • mtr
    • None

    Description

      The mcs247_from_unixtime_funtion test works only if the machine time zone is GMT (e.g. on CI).

      If the local time zone is different, it fails with about the following diff:

      CURRENT_TEST: columnstore/basic.mcs247_from_unixtime_funtion
      --- /home/bar/maria-git/s10.6.cs6.MCOL-4414/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/mcs247_from_unixtime_funtion.result	2021-06-02 14:05:58.774068995 +0400
      +++ /home/bar/maria-git/s10.6.cs6.MCOL-4414/storage/columnstore/columnstore/mysql-test/columnstore/basic/r/mcs247_from_unixtime_funtion.reject	2021-06-03 12:52:08.799494420 +0400
      @@ -14,36 +14,36 @@
       INSERT INTO t1 VALUES(9913, 98765.4321, repeat('q', 5), '09-12-11', '01:08:59');
       SELECT FROM_UNIXTIME(0) FROM t1 LIMIT 1;
       FROM_UNIXTIME(0)
      -1970-01-01 00:00:00
      +1970-01-01 04:00:00
       SELECT FROM_UNIXTIME(-1) FROM t1 LIMIT 1;
       FROM_UNIXTIME(-1)
       NULL
       SELECT FROM_UNIXTIME(1) FROM t1 LIMIT 1;
       FROM_UNIXTIME(1)
      -1970-01-01 00:00:01
      +1970-01-01 04:00:01
       SELECT FROM_UNIXTIME(1547432997) FROM t1 LIMIT 1;
       FROM_UNIXTIME(1547432997)
      -2019-01-14 02:29:57
      +2019-01-14 06:29:57
       SELECT FROM_UNIXTIME('1547432997') FROM t1 LIMIT 1;
       FROM_UNIXTIME('1547432997')
      -2019-01-14 02:29:57.000000
      +2019-01-14 06:29:57.000000
       SELECT FROM_UNIXTIME(1547432997)+0 FROM t1 LIMIT 1;
       FROM_UNIXTIME(1547432997)+0
      -20190114022957
      +20190114062957
       SELECT FROM_UNIXTIME(1547432997, '%Y %D %M %h:%i:%s %x') FROM t1 LIMIT 1;
       FROM_UNIXTIME(1547432997, '%Y %D %M %h:%i:%s %x')
      -2019 14th January 02:29:57 2019
      +2019 14th January 06:29:57 2019
       SELECT FROM_UNIXTIME(2047430881)-8101 FROM t1 LIMIT 1;
       FROM_UNIXTIME(2047430881)-8101
      -20341118016700
      +20341118056700
       SELECT t1_INT, FROM_UNIXTIME(t1_INT) FROM t1 ORDER BY 1;
       t1_INT	FROM_UNIXTIME(t1_INT)
       -7299	NULL
      -103	1970-01-01 00:01:43
      -9913	1970-01-01 02:45:13
      +103	1970-01-01 04:01:43
      +9913	1970-01-01 06:45:13
       SELECT t1_DECIMAL, FROM_UNIXTIME(t1_DECIMAL) FROM t1 ORDER BY 1;
       t1_DECIMAL	FROM_UNIXTIME(t1_DECIMAL)
      -111.99000	1970-01-01 00:01:51.99000
      -1234.56990	1970-01-01 00:20:34.56990
      -98765.43210	1970-01-02 03:26:05.43210
      +111.99000	1970-01-01 04:01:51.99000
      +1234.56990	1970-01-01 04:20:34.56990
      +98765.43210	1970-01-02 07:26:05.43210
       DROP DATABASE mcs247_db;
       
      mysqltest: Result content mismatch
       
       - saving '/home/bar/maria-git/s10.6.cs6.MCOL-4414/BUILD-DEB/mysql-test/var/log/columnstore/basic.mcs247_from_unixtime_funtion/' to '/home/bar/maria-git/s10.6.cs6.MCOL-4414/BUILD-DEB/mysql-test/var/log/basic.mcs247_from_unixtime_funtion/'
      

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.