Bug #43241 Inconsistancy in warnings on create table / create tablespace with unknown engin
Submitted: 26 Feb 2009 17:54
Reporter: Hartmut Holzgraefe Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Disk Data Severity:S3 (Non-critical)
Version:mysql-5.1-telco-6.3 OS:Any
Assigned to: CPU Architecture:Any
Tags: mysql-5.1.31-telco-6.3.22
Triage: Triaged: D4 (Minor) / R1 (None/Negligible) / E1 (None/Negligible)

[26 Feb 2009 17:54] Hartmut Holzgraefe
Description:
When trying to create a table with an unknown storage engine like

  mysql> create table t1 (id int) engine xxx;
  Query OK, 0 rows affected, 2 warnings (0.81 sec)

i get the following warnings:

  mysql> show warnings;
  +---------+------+------------------------------------------------+
  | Level   | Code | Message                                        |
  +---------+------+------------------------------------------------+
  | Warning | 1286 | Unknown table engine 'xxx'                     | 
  | Warning | 1266 | Using storage engine ndbcluster for table 't1' | 
  +---------+------+------------------------------------------------+

On creating a log file group or table space i only get the first 
warning though, the information which storage engine was actually
used as a replacement for the invalid 'xxx' is not given here:

  mysql> CREATE LOGFILE GROUP lg_1     
         ADD UNDOFILE 'undo_1.log'     
         INITIAL_SIZE 16M     
         UNDO_BUFFER_SIZE 2M     ENGINE xxx;
  Query OK, 0 rows affected, 1 warning (3.40 sec)

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

  mysql> CREATE TABLESPACE ts_1     
         ADD DATAFILE 'data_1.dat'     
         USE LOGFILE GROUP lg_1     
         INITIAL_SIZE 32M     ENGINE xxx;
  Query OK, 0 rows affected, 1 warning (5.12 sec)

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

How to repeat:
see description above

Suggested fix:
Generate 2nd warning stating the actual storage engine used just like it is done for CREATE TABLE already