DROP DATABASE IF EXISTS mcol_5480;
CREATE DATABASE mcol_5480;
USE mcol_5480;
SHOW VARIABLES LIKE 'columnstore_use_import_for_batchinsert';
Variable_name	Value
columnstore_use_import_for_batchinsert	ON
CREATE TABLE t1 (cmediumint MEDIUMINT, ctimestamp TIMESTAMP, ctime TIME) engine=columnstore;
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
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
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
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
DROP TABLE t1;
CREATE TABLE t1 (cmediumint MEDIUMINT) engine=columnstore;
LOAD DATA INFILE "DATADIR/mcol5480.txt" INTO TABLE t1 FIELDS TERMINATED BY "|";;
SELECT * FROM t1;
cmediumint
-8388608
-8388607
-1000
-1
1
1000
8388607
NULL
DROP TABLE t1;
CREATE TABLE t1 (cmediumint MEDIUMINT UNSIGNED) engine=columnstore;
LOAD DATA INFILE "DATADIR/mcol5480.txt" INTO TABLE t1 FIELDS TERMINATED BY "|";;
SELECT * FROM t1;
cmediumint
0
1
1000
8388607
NULL
16777215
DROP TABLE t1;
CREATE TABLE t1 (ctimestamp TIMESTAMP, ctime TIME) engine=columnstore;
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
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
DROP TABLE t1;
CREATE TABLE t1 (ctime TIME) engine=columnstore;
LOAD DATA INFILE "DATADIR/mcol5480.txt" INTO TABLE t1 FIELDS TERMINATED BY "|";;
SELECT * FROM t1;
ctime
11:58:28
11:58:38
11:58:48
11:58:58
12:58:28
13:58:28
14:58:28
15:58:28
DROP TABLE t1;
DROP DATABASE mcol_5480;