|
IMO, this should work or be prohibited to prevent disasters. I tried InnoDB, MyISAM, CSV and the result is the same. Note that the default table type should be used, so the alter table should work in theory.
MariaDB [test]> CREATE TABLE t (c INT) ENGINE = InnoDB;
|
Query OK, 0 rows affected (0.51 sec)
|
|
MariaDB [test]> INSERT INTO t VALUES (1), (2), (3);
|
Query OK, 3 rows affected (0.07 sec)
|
Records: 3 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> ALTER TABLE t ENGINE = CONNECT;
|
Query OK, 0 rows affected, 2 warnings (0.46 sec)
|
Records: 0 Duplicates: 0 Warnings: 2
|
|
Warning (Code 1105): No table_type. Will be set to DOS
|
Warning (Code 1105): Wrong command in create, please contact CONNECT team
|
MariaDB [test]> SELECT * FROM t;
|
Empty set, 1 warning (0.00 sec)
|
|
Warning (Code 1105): Open(rb) error 2 on /usr/local/mariadb-10.0.5-linux-x86_64/data/./test/t.dos: No such file or directory
|
|