Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Do
-
None
-
None
Description
During insertion, CS is truncating a string literal containing a null terminating character to the string before the character. InnoDB however does the insert correctly.
Here is an example:
MariaDB [test]> create table c1 (a varchar(10))engine=columnstore;
|
Query OK, 0 rows affected (0.218 sec)
|
|
MariaDB [test]> insert into c1 values ('a\0b');
|
Query OK, 1 row affected (0.235 sec)
|
|
MariaDB [test]> select * from c1;
|
+------+
|
| a |
|
+------+
|
| a |
|
+------+
|
1 row in set (0.076 sec)
|
|
MariaDB [test]> create table i1 (a varchar(10));
|
Query OK, 0 rows affected (0.008 sec)
|
|
MariaDB [test]> insert into i1 values ('a\0b');
|
Query OK, 1 row affected (0.052 sec)
|
|
MariaDB [test]> select * from i1;
|
+------+
|
| a |
|
+------+
|
| a b |
|
+------+
|
1 row in set (0.001 sec)
|
|