Description:
When trying to create a table of type that doesn't exist, a MyISAM table is created instead of issuing an error.
How to repeat:
mysql> select version();+-----------------+
| version() |
+-----------------+
| 4.0.12-standard |
+-----------------+
1 row in set (0.00 sec)
mysql> show variables like 'have_innodb';
+---------------+----------+
| Variable_name | Value |
+---------------+----------+
| have_innodb | DISABLED |
+---------------+----------+
1 row in set (0.00 sec)
mysql> create table innodb (
-> id int primary key auto_increment,
-> fk int,
-> index index_fk (fk)
-> ) type=innodb;
Query OK, 0 rows affected (0.01 sec)
mysql> show table status like 'innodb' \G
*************************** 1. row ***************************
Name: innodb
Type: MyISAM
Row_format: Fixed
Rows: 0
Avg_row_length: 0
Data_length: 0
Max_data_length: 38654705663
Index_length: 1024
Data_free: 0
Auto_increment: 1
Create_time: 2003-04-08 14:50:59
Update_time: 2003-04-08 14:50:59
Check_time: NULL
Create_options:
Comment:
1 row in set (0.00 sec)
Suggested fix:
Issue an error.
Description: When trying to create a table of type that doesn't exist, a MyISAM table is created instead of issuing an error. How to repeat: mysql> select version();+-----------------+ | version() | +-----------------+ | 4.0.12-standard | +-----------------+ 1 row in set (0.00 sec) mysql> show variables like 'have_innodb'; +---------------+----------+ | Variable_name | Value | +---------------+----------+ | have_innodb | DISABLED | +---------------+----------+ 1 row in set (0.00 sec) mysql> create table innodb ( -> id int primary key auto_increment, -> fk int, -> index index_fk (fk) -> ) type=innodb; Query OK, 0 rows affected (0.01 sec) mysql> show table status like 'innodb' \G *************************** 1. row *************************** Name: innodb Type: MyISAM Row_format: Fixed Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 38654705663 Index_length: 1024 Data_free: 0 Auto_increment: 1 Create_time: 2003-04-08 14:50:59 Update_time: 2003-04-08 14:50:59 Check_time: NULL Create_options: Comment: 1 row in set (0.00 sec) Suggested fix: Issue an error.