Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.2(EOL)
-
None
Description
MariaDB [test]> CREATE TABLE t1 (i INT); |
Query OK, 0 rows affected (0.20 sec) |
|
MariaDB [test]> ALTER TABLE t1 ROW_FORMAT=FIXED; |
ERROR 1478 (HY000): Table storage engine 'InnoDB' does not support the create option 'ROW_TYPE' |
In fact, the engine supports the option, and the option name is wrong. What it doesn't support is the value.
CREATE TABLE behaves differently:
MariaDB [test]> CREATE TABLE t2 (i INT) ROW_FORMAT=FIXED; |
ERROR 1005 (HY000): Can't create table `test`.`t2` (errno: 140 "Wrong create options") |
MariaDB [test]> SHOW WARNINGS;
|
+---------+------+--------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+--------------------------------------------------------------------+
|
| Warning | 1478 | InnoDB: invalid ROW_FORMAT specifier. |
|
| Error | 1005 | Can't create table `test`.`t2` (errno: 140 "Wrong create options") | |
| Warning | 1030 | Got error 140 "Wrong create options" from storage engine InnoDB | |
+---------+------+--------------------------------------------------------------------+ |
3 rows in set (0.00 sec) |
At least the message for error 1478 is better here.
Attachments
Issue Links
- relates to
-
MDEV-15116 Wrong error code/message 1478: 'Table storage engine 'InnoDB' does not support the create option 'ENCRYPTION_KEY_ID'
- Open