Bug #42616 alter table X engine=mysiam; (misspelt engine..)

• Submitted: 5 Feb 2009 11:16
• Modified: 5 Feb 2009 12:22
• Reporter: Johan Andersson
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.1.31
• OS: Any
• CPU Architecture: Any
• Tags: ALTER TABLE, ALTER TABLE ENGINE

[5 Feb 2009 11:16] Johan Andersson

Description:
It is possible to do
 alter table X engine=mysiam;
This should generate a parse error (there is no engine called 'mysiam').

How to repeat:
create table x(a integer) engine=innodb;
alter table x engine=mysiam;

[5 Feb 2009 12:22] MySQL Verification Team

Thank you for the bug report. If you want an error instead of a warning use the below sql_mode:

c:\dbs>c:\dbs\5.1\bin\mysql -uroot --port=3510 --prompt="mysql 5.1 >"
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.31-nt-debug-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql 5.1 >use test
Database changed
mysql 5.1 >create table x(a integer) engine=innodb;
Query OK, 0 rows affected (0.25 sec)

mysql 5.1 >alter table x engine=mysiam;
Query OK, 0 rows affected, 1 warning (0.41 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql 5.1 >show warnings;
+---------+------+-------------------------------+
| Level   | Code | Message                       |
+---------+------+-------------------------------+
| Warning | 1286 | Unknown table engine 'mysiam' |
+---------+------+-------------------------------+
1 row in set (0.03 sec)

mysql 5.1 >set sql_mode = NO_ENGINE_SUBSTITUTION;
Query OK, 0 rows affected (0.41 sec)

mysql 5.1 >alter table x engine=mysiam;
ERROR 1286 (42000): Unknown table engine 'mysiam'
mysql 5.1 >