Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5890

CONNECT and CHAR(0)

    XMLWordPrintable

    Details

      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)

        Attachments

          Activity

            People

            Assignee:
            bertrandop Olivier Bertrand
            Reporter:
            f_razzoli Federico Razzoli
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: