Bug #31717 No errors, only warnings, when creating tablespace fails as ndb is not enabled
Submitted: 19 Oct 2007 14:05 Modified: 26 Oct 2007 17:00
Reporter: Hartmut Holzgraefe Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Disk Data Severity:S3 (Non-critical)
Version:mysql-5.1 OS:Linux
Assigned to: CPU Architecture:Any
Tags: 5.1.22

[19 Oct 2007 14:05] Hartmut Holzgraefe
Description:
Trying to create a NDB table space withoud cluster being activated produces only warnings, no errors.

How to repeat:
mysql> CREATE LOGFILE GROUP lg_1
    ->     ADD UNDOFILE 'undo_1.dat'
    ->     INITIAL_SIZE 16M
    ->     UNDO_BUFFER_SIZE 2M
    ->     ENGINE NDB;
Query OK, 0 rows affected, 2 warnings (0.00 sec)

mysql> show warnings;
+---------+------+------------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                        |
+---------+------+------------------------------------------------------------------------------------------------+
| Warning | 1286 | Unknown table engine 'NDB'                                                                     | 
| Error   | 1466 | Table storage engine 'MyISAM' does not support the create option 'TABLESPACE or LOGFILE GROUP' | 
+---------+------+------------------------------------------------------------------------------------------------+
2 rows in set (0.01 sec)

Suggested fix:
Should report an error, either about NDB engine being unknown or about MyISAM not supporting table spaces.