Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.0.6
-
None
-
None
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.
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 |