Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
2025-9
Description
the text file:
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|\N|15:58:28|
|
Columnstore, server 10.6:
CREATE TABLE t1 (ctimestamp TIMESTAMP, cmediumint MEDIUMINT, ctime TIME) engine=columnstore;
|
LOAD DATA INFILE "mcol5480.txt" INTO TABLE t1 FIELDS TERMINATED BY "|";
|
MariaDB [test]> 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 |
|
+---------------------+------------+----------+
|
|
Columnstore, server 11.4:
MariaDB [mcol_5480]> 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 | 0 | NULL |
|
+------------+------------+-------+
|
8 rows in set (0.057 sec)
|
|
InnoDB, both 10.6, 11.4:
MariaDB [mcol_5480]> CREATE TABLE t2 (ctimestamp TIMESTAMP, cmediumint MEDIUMINT, ctime TIME);
|
Query OK, 0 rows affected (0.019 sec)
|
|
|
MariaDB [mcol_5480]> LOAD DATA INFILE "mcol5480.txt" INTO TABLE t2 FIELDS TERMINATED BY "|";
|
Query OK, 8 rows affected (0.001 sec)
|
Records: 8 Deleted: 0 Skipped: 0 Warnings: 0
|
|
|
MariaDB [mcol_5480]> select * from t2;
|
+------------+------------+-------+
|
| 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 |
|
+------------+------------+-------+
|
|
In the case of the Columnstore engine, in 11.4, the difference is:
- "\N" interpreted as 0 instead of NULL (type cmediumint)
- the values next column ( "15:58:28" ) seems to be ignored due to misinterpretation of \N
Attachments
Issue Links
- relates to
-
MCOL-6002 Fix server 11.4 issues
-
- Closed
-
- mentioned on
