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)
|
|