Bug #32300 Inconsistent table-creation error messages
Submitted: 12 Nov 2007 22:49 Modified: 12 Oct 2011 16:48
Reporter: Paul Dubois Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.1 and up OS:Any
Assigned to: Jon Olav Hauglid CPU Architecture:Any
Triage: Triaged: D4 (Minor)

[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] Miguel Solorzano
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.