Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.9
-
None
Description
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) |