Converting any_engine -> CONNECT deletes data

Description

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.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 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

Environment

None

Status

Assignee

Olivier Bertrand

Reporter

Federico Razzoli

Labels

None

External issue ID

None

External issue ID

None

Fix versions

Affects versions

10.0.6

Priority

Critical