Details

    • Type: Bug
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 10.0.10
    • Fix Version/s: 10.0.11
    • Component/s: None
    • Labels:

      Description

      MariaDB [test]> CREATE TABLE t (a INT) ENGINE=CONNECT TABLE_TYPE=csv;
      Query OK, 0 rows affected, 1 warning (0.18 sec)
      
      Warning (Code 1105): No file name. Table will use t.csv
      MariaDB [test]> INSERT INTO t VALUES (1);
      Query OK, 1 row affected (0.00 sec)
      
      MariaDB [test]> ALTER TABLE t TABLE_TYPE=fmt;
      ERROR 1296 (HY000): Got error 174 'Writing FMT files is not implemented yet' from CONNECT
      Warning (Code 1105): Congratulation, you just created a read-only void table!
      Error (Code 1296): Got error 174 'Writing FMT files is not implemented yet' from CONNECT
      MariaDB [test]> SHOW CREATE TABLE t;
      +-------+--------------------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                                           |
      +-------+--------------------------------------------------------------------------------------------------------+
      | t     | CREATE TABLE `t` (
        `a` int(11) DEFAULT NULL
      ) ENGINE=CONNECT DEFAULT CHARSET=latin1 `TABLE_TYPE`=csv |
      +-------+--------------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)
      

      The error is ok. But the warning 'Congratulation, you just created a read-only void table!' is misleading in this case. Since the table is not empty, one could think a disaster occurred.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            bertrandop Olivier Bertrand added a comment -

            This warning is suppressed when altering tables.

            Show
            bertrandop Olivier Bertrand added a comment - This warning is suppressed when altering tables.

              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:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 hour
                  1h