bugfixes.mcol-5480 test fails if default zimezone is not GMT

-- /usr/share/mariadb-test/plugin/columnstore/columnstore/bugfixes/mcol-5480.result	2025-10-27 17:56:22.000000000 +0100

+++ /usr/share/mariadb-test/plugin/columnstore/columnstore/bugfixes/mcol-5480.reject	2025-10-27 22:37:44.390568846 +0100

@@ -8,49 +8,49 @@

 LOAD DATA INFILE "DATADIR/mcol5480.txt" INTO TABLE t1 FIELDS TERMINATED BY "|";;

 SELECT * FROM t1;

 cmediumint	ctimestamp	ctime

--8388608	2020-08-13 03:14:07	11:58:28

--8388607	2020-08-14 03:14:07	11:58:38

--1000	2020-08-15 03:14:07	11:58:48

--1	2020-08-16 03:14:07	11:58:58

-1	2020-08-13 03:14:08	12:58:28

-1000	2020-08-13 03:14:09	13:58:28

-8388607	2020-08-13 03:14:10	14:58:28

-NULL	2020-08-13 03:14:11	15:58:28

+-8388608	2020-08-13 02:14:07	11:58:28

+-8388607	2020-08-14 02:14:07	11:58:38

+-1000	2020-08-15 02:14:07	11:58:48

+-1	2020-08-16 02:14:07	11:58:58

+1	2020-08-13 02:14:08	12:58:28

+1000	2020-08-13 02:14:09	13:58:28

+8388607	2020-08-13 02:14:10	14:58:28

+NULL	2020-08-13 02:14:11	15:58:28

 DROP TABLE t1;

 CREATE TABLE t1 (ctimestamp TIMESTAMP, cmediumint MEDIUMINT, ctime TIME) engine=columnstore;

 LOAD DATA INFILE "DATADIR/mcol5480.txt" INTO TABLE t1 FIELDS TERMINATED BY "|";;

 SELECT * FROM t1;

 ctimestamp	cmediumint	ctime

-2020-08-13 03:14:07	-8388608	11:58:28

-2020-08-14 03:14:07	-8388607	11:58:38

-2020-08-15 03:14:07	-1000	11:58:48

-2020-08-16 03:14:07	-1	11:58:58

-2020-08-13 03:14:08	1	12:58:28

-2020-08-13 03:14:09	1000	13:58:28

-2020-08-13 03:14:10	8388607	14:58:28

-2020-08-13 03:14:11	NULL	15:58:28

+2020-08-13 02:14:07	-8388608	11:58:28

+2020-08-14 02:14:07	-8388607	11:58:38

+2020-08-15 02:14:07	-1000	11:58:48

+2020-08-16 02:14:07	-1	11:58:58

+2020-08-13 02:14:08	1	12:58:28

+2020-08-13 02:14:09	1000	13:58:28

+2020-08-13 02:14:10	8388607	14:58:28

+2020-08-13 02:14:11	NULL	15:58:28

 DROP TABLE t1;

 CREATE TABLE t1 (cmediumint MEDIUMINT UNSIGNED, ctimestamp TIMESTAMP, ctime TIME) engine=columnstore;

 LOAD DATA INFILE "DATADIR/mcol5480.txt" INTO TABLE t1 FIELDS TERMINATED BY "|";;

 SELECT * FROM t1;

 cmediumint	ctimestamp	ctime

-0	2020-08-12 03:14:08	12:58:18

-1	2020-08-13 03:14:08	12:58:28

-1000	2020-08-13 03:14:09	13:58:28

-8388607	2020-08-13 03:14:10	14:58:28

-NULL	2020-08-13 03:14:11	15:58:28

-16777215	2020-08-13 03:14:11	15:58:28

+0	2020-08-12 02:14:08	12:58:18

+1	2020-08-13 02:14:08	12:58:28

+1000	2020-08-13 02:14:09	13:58:28

+8388607	2020-08-13 02:14:10	14:58:28

+NULL	2020-08-13 02:14:11	15:58:28

+16777215	2020-08-13 02:14:11	15:58:28

 DROP TABLE t1;

 CREATE TABLE t1 (ctimestamp TIMESTAMP, cmediumint MEDIUMINT UNSIGNED, ctime TIME) engine=columnstore;

 LOAD DATA INFILE "DATADIR/mcol5480.txt" INTO TABLE t1 FIELDS TERMINATED BY "|";;

 SELECT * FROM t1;

 ctimestamp	cmediumint	ctime

-2020-08-12 03:14:08	0	12:58:18

-2020-08-13 03:14:08	1	12:58:28

-2020-08-13 03:14:09	1000	13:58:28

-2020-08-13 03:14:10	8388607	14:58:28

-2020-08-13 03:14:11	NULL	15:58:28

-2020-08-13 03:14:11	16777215	15:58:28

+2020-08-12 02:14:08	0	12:58:18

+2020-08-13 02:14:08	1	12:58:28

+2020-08-13 02:14:09	1000	13:58:28

+2020-08-13 02:14:10	8388607	14:58:28

+2020-08-13 02:14:11	NULL	15:58:28

+2020-08-13 02:14:11	16777215	15:58:28

 DROP TABLE t1;

 CREATE TABLE t1 (cmediumint MEDIUMINT) engine=columnstore;

 LOAD DATA INFILE "DATADIR/mcol5480.txt" INTO TABLE t1 FIELDS TERMINATED BY "|";;

@@ -80,27 +80,27 @@

 LOAD DATA INFILE "DATADIR/mcol5480.txt" INTO TABLE t1 FIELDS TERMINATED BY "|";;

 SELECT * FROM t1;

 ctimestamp	ctime

-2020-08-13 03:14:07	11:58:28

-2020-08-14 03:14:07	11:58:38

-2020-08-15 03:14:07	11:58:48

-2020-08-16 03:14:07	11:58:58

-2020-08-13 03:14:08	12:58:28

-2020-08-13 03:14:09	13:58:28

-2020-08-13 03:14:10	14:58:28

-2020-08-13 03:14:11	15:58:28

+2020-08-13 02:14:07	11:58:28

+2020-08-14 02:14:07	11:58:38

+2020-08-15 02:14:07	11:58:48

+2020-08-16 02:14:07	11:58:58

+2020-08-13 02:14:08	12:58:28

+2020-08-13 02:14:09	13:58:28

+2020-08-13 02:14:10	14:58:28

+2020-08-13 02:14:11	15:58:28

 DROP TABLE t1;

 CREATE TABLE t1 (ctimestamp TIMESTAMP) engine=columnstore;

 LOAD DATA INFILE "DATADIR/mcol5480.txt" INTO TABLE t1 FIELDS TERMINATED BY "|";;

 SELECT * FROM t1;

 ctimestamp

-2020-08-13 03:14:07

-2020-08-14 03:14:07

-2020-08-15 03:14:07

-2020-08-16 03:14:07

-2020-08-13 03:14:08

-2020-08-13 03:14:09

-2020-08-13 03:14:10

-2020-08-13 03:14:11

+2020-08-13 02:14:07

+2020-08-14 02:14:07

+2020-08-15 02:14:07

+2020-08-16 02:14:07

+2020-08-13 02:14:08

+2020-08-13 02:14:09

+2020-08-13 02:14:10

+2020-08-13 02:14:11

 DROP TABLE t1;

 CREATE TABLE t1 (ctime TIME) engine=columnstore;

 LOAD DATA INFILE "DATADIR/mcol5480.txt" INTO TABLE t1 FIELDS TERMINATED BY "|";;

Result content mismatch