Bug #32238 Engine name is not properly checked in Create Table statement

• Submitted: 9 Nov 2007 16:17
• Modified: 9 Nov 2007 16:38
• Reporter: Jeb Mershon
• Status: Not a Bug
• Category: MySQL Server: DDL
• Severity: S3 (Non-critical)
• Version: 6.0.3-alpha
• OS: Linux (Fedora 6 - 64 bit)
• CPU Architecture: Any

[9 Nov 2007 16:17] Jeb Mershon

Description:
When an invalid engine is specified on a Create Table statement, the table is created with MyISAM and no warning is generated.

How to repeat:
use test;
create table t1 (col1 int) engine=XYZ;
show create table t1;

[9 Nov 2007 16:38] MySQL Verification Team

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 6.0.3-alpha-debug Source distribution

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

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

mysql> create table t1 (col1 int) engine=XYZ;
ERROR 1286 (42000): Unknown table engine 'XYZ'
mysql>