Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.0.6
-
None
-
None
Description
IMO, this should work, or should be prohibited to prevent disasters:
MariaDB [test]> CREATE TABLE t (c INT NOT NULL) ENGINE=CONNECT; |
Query OK, 0 rows affected, 2 warnings (0.13 sec) |
|
Warning (Code 1105): No table_type. Will be set to DOS |
Warning (Code 1105): No file name. Table will use t.dos |
MariaDB [test]> INSERT INTO t VALUES (1), (2), (3); |
Query OK, 3 rows affected (0.00 sec) |
Records: 3 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> SELECT * FROM t; |
+---+ |
| c |
|
+---+ |
| 1 |
|
| 2 |
|
| 3 |
|
+---+ |
3 rows in set (0.01 sec) |
|
MariaDB [test]> ALTER TABLE t ENGINE = InnoDB; |
Query OK, 1 row affected (0.71 sec)
|
Records: 1 Duplicates: 0 Warnings: 0
|
|
MariaDB [test]> SELECT * FROM t; |
+---+ |
| c |
|
+---+ |
| 0 |
|
+---+ |
1 row in set (0.01 sec) |