[MDEV-5890] CONNECT and CHAR(0) Created: 2014-03-17  Updated: 2014-03-19  Resolved: 2014-03-19

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.9
Fix Version/s: 10.0.11

Type: Bug Priority: Minor
Reporter: Federico Razzoli Assignee: Olivier Bertrand
Resolution: Fixed Votes: 0
Labels: connect-engine


 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)



 Comments   
Comment by Olivier Bertrand [ 2014-03-19 ]

I chose to reject a 0 length char column in CREATE TABLE. Is that the best? Personally I don't see the usefulness of such a column but you may think differently. Let me know.

Comment by Federico Razzoli [ 2014-03-19 ]

Other engines allow this, but probably it would be useless for CONNECT (particularly if TABLE_TYPE does not allow NULLs). I just suggest that a proper error is shown

Generated at Thu Feb 08 07:07:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.