Bug #32300 Inconsistent table-creation error messages

• Submitted: 12 Nov 2007 22:49
• Modified: 12 Oct 2011 16:48
• Reporter: Paul DuBois
• Status: Can't repeat
• Category: MySQL Server: Errors
• Severity: S3 (Non-critical)
• Version: 5.1 and up
• OS: Any
• Assigned to: Jon Olav Hauglid
• CPU Architecture: Any

[12 Nov 2007 22:49] Paul DuBois

Description:
In 5.1 and up, if you try to create a table with a non-loaded storage engine, you get two warnings:

mysql> CREATE TABLE t (i INT) ENGINE ABC;
Query OK, 0 rows affected, 2 warnings (0.04 sec)

mysql> SHOW WARNINGS;
+---------+------+-------------------------------------------+
| Level   | Code | Message                                   |
+---------+------+-------------------------------------------+
| Warning | 1286 | Unknown table engine 'ABC'                | 
| Warning | 1266 | Using storage engine MyISAM for table 't' | 
+---------+------+-------------------------------------------+
2 rows in set (0.00 sec)

But one warning says "table engine" and the other says "storage engine". Both should say "storage engine".

How to repeat:
CREATE TABLE t (i INT) ENGINE ABC;
SHOW WARNINGS;

Suggested fix:
Change the first error message.

[12 Nov 2007 23:00] MySQL Verification Team

Thank you for the bug report.

[12 Oct 2011 16:49] Jon Olav Hauglid

Already fixed on 5.5 and 5.6:

ER_UNKNOWN_STORAGE_ENGINE 42000 
        eng "Unknown storage engine '%s'"

Closing the bug.