Bug #29373 ERROR 1289 (HY000): The 'UNKNOWN' feature is disabled;

Submitted: 26 Jun 2007 20:11 Modified: 26 Jun 2007 20:22
Reporter: Ronald Bradford Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.1.16/6.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: CREATE TABLE, eror message, SQL_MODE

[26 Jun 2007 20:11] Ronald Bradford
Description:
When attempting to create a table with sql_mode NO_ENGINE_SUBSTITUTION for a DISABLED engine, you get an error message with 'UNKNOWN'.

In 5.0, appropriate message states 'InnodB' when this was used.
In 5.1.16 and 6.0.0 it shows UNKNOWN

In 5.1.19 you get a completely different error message. 

How to repeat:
bin/mysqld_safe --skip-innodb &
bin/mysql -uroot test

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.0.37    | 
+-----------+
1 row in set (0.01 sec)
mysql> set session sql_mode=NO_ENGINE_SUBSTITUTION;
Query OK, 0 rows affected (0.00 sec)

mysql> create table T2 (id INT UNSIGNED NOT NULL) ENGINE=InnoDB;
ERROR 1289 (HY000): The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

mysql> select version();
+-------------+
| version()   |
+-------------+
| 6.0.0-alpha | 
+-------------+
1 row in set (0.00 sec)
mysql> set session sql_mode=NO_ENGINE_SUBSTITUTION;
Query OK, 0 rows affected (0.00 sec)

mysql> create table T2 (id INT UNSIGNED NOT NULL) ENGINE=InnoDB;
ERROR 1289 (HY000): The 'UNKNOWN' feature is disabled; you need MySQL built with 'UNKNOWN' to have it working

mysql> select version();
+-------------+
| version()   |
+-------------+
| 5.1.19-beta | 
+-------------+
1 row in set (0.00 sec)

mysql> set session sql_mode=NO_ENGINE_SUBSTITUTION;
Query OK, 0 rows affected (0.00 sec)

mysql> create table T2 (id INT UNSIGNED NOT NULL) ENGINE=InnoDB;
ERROR 1286 (42000): Unknown table engine 'InnoDB'
[26 Jun 2007 20:22] Sveta Smirnova
Thank you for the report.

I can not repeat described behaviour with current development sources, although bug is repeatable with 6.0.0-alpha

Please wait next build.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.