Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.6.1, 6.1.1
-
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
- relates to
-
MCOL-4659 Server MTR failures on ColumnStore tests
- Open