Should CONNECT support CHAR(0)? I tried with a CONNECT csv table and it doesn't work. However, with CSV engine it works.
CONNECT:
MariaDB [test]> CREATE TABLE ttt (a CHAR(0) NOT NULL) ENGINE=CONNECT TABLE_TYPE=CSV FILE_NAME='ttt.csv';
|
Query OK, 0 rows affected (0.13 sec)
|
|
MariaDB [test]> INSERT INTO ttt VALUES ('');
|
ERROR 1296 (HY000): Got error 3 'Invalid type CHAR for column a' from CONNECT
|
(if it isn't supported, in my opinion, a more correct error is expected on CREATE TABLE)
CSV:
MariaDB [test]> CREATE TABLE ttt (a CHAR(0) NOT NULL) ENGINE=CSV;Query OK, 0 rows affected (0.15 sec)
|
|
MariaDB [test]> INSERT INTO ttt VALUES ('');
|
Query OK, 1 row affected (0.10 sec)
|
|
MariaDB [test]> SELECT * FROM ttt;
|
+---+
|
| a |
|
+---+
|
| |
|
+---+
|
1 row in set (0.00 sec)
|
Bug
Minor