For QA: With this issue, we are fixing a crash while performing an LDI in a table which has the character set utf8 at the table level. Here are steps to reproduce:
MariaDB [test]> create table dummy (a varchar(255), b text(255), c varchar(255)) default character set utf8 engine=columnstore;
|
Query OK, 0 rows affected (0.308 sec)
|
|
MariaDB [test]> load data local infile './mcol4005.txt' into table dummy fields enclosed by '"' terminated by ',';
|
ERROR 2013 (HY000): Lost connection to MySQL server during query
|
MariaDB [test]>
|
Here, mcol4005.txt contains the following
tntnatbry@tntnatbry:~/git-projects/server/storage/columnstore$ cat mcol4005.txt
|
"field1","\\","field3"
|
"field1",\N,"field3"
|
"field1","field2","field3"
|
In addition, if we remove the character set property from the table creation, the LDI works, but it does not insert the "\" in the data file properly. We are also fixing this. Here are steps to reproduce:
MariaDB [test]> create table dummy (a varchar(255), b text(255), c varchar(255)) engine=columnstore;
|
Query OK, 0 rows affected (0.273 sec)
|
|
MariaDB [test]> load data local infile './mcol4005.txt' into table dummy fields enclosed by '"' terminate
|
d by ',';
|
Query OK, 3 rows affected (1.321 sec)
|
Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
|
|
MariaDB [test]> select * from dummy;
|
+--------+--------+--------+
|
| a | b | c |
|
+--------+--------+--------+
|
| field1 | | NULL |
|
| field1 | NULL | field3 |
|
| field1 | field2 | field3 |
|
+--------+--------+--------+
|
3 rows in set (0.090 sec)
|
For QA: With this issue, we are fixing a crash while performing an LDI in a table which has the character set utf8 at the table level. Here are steps to reproduce:
MariaDB [test]>
Here, mcol4005.txt contains the following
In addition, if we remove the character set property from the table creation, the LDI works, but it does not insert the "\" in the data file properly. We are also fixing this. Here are steps to reproduce:
Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
| a | b | c |
| field1 | field2 | field3 |