Bug #43241 Inconsistancy in warnings on create table / create tablespace with unknown engin

• Submitted: 26 Feb 2009 17:54
• Reporter: Hartmut Holzgraefe
• Status: Verified
• Category: MySQL Cluster: Disk Data
• Severity: S3 (Non-critical)
• Version: mysql-5.1-telco-6.3
• OS: Any
• CPU Architecture: Any
• Tags: mysql-5.1.31-telco-6.3.22

[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