Bug #19695 Partitions: ignoring no_table_options
Submitted: 10 May 2006 17:42 Modified: 14 Jun 2006 1:23
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:5.1.10-beta-debug OS:Linux (SUSE 10.0 / 64-bit)
Assigned to: Mikael Ronström CPU Architecture:Any

[10 May 2006 17:42] Peter Gulutzan
Description:
The MySQL Reference Manual says that, if sql_mode=no_table_options,
"Do not print MySQL-specific table options (such as ENGINE) in the output
of SHOW CREATE TABLE. This mode is used by mysqldump ..."
But I see the ENGINE clause in the partitions section.
Not a bug? I guess it depends why mysqldump needs the mode.

How to repeat:
mysql> create table t9 (s1 int) partition by list (s1) (partition p1 values in (1));
Query OK, 0 rows affected (0.01 sec)

mysql> show create table t9;
+-------+-------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                      |
+-------+-------------------------------------------------------------------------------------------------------------------+
| t9    | CREATE TABLE t9 (
  s1 int(11) DEFAULT NULL
) PARTITION BY LIST (s1) (PARTITION p1 VALUES IN (1) ENGINE = MyISAM) |
+-------+-------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
[10 May 2006 18:26] MySQL Verification Team
Thank you for the bug report.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.1.10-beta-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table v (id int) engine=myisam;
Query OK, 0 rows affected (0.01 sec)

mysql> show create table v;
+-------+--------------------------------------------------+
| Table | Create Table                                     |
+-------+--------------------------------------------------+
| v     | CREATE TABLE `v` (
  `id` int(11) DEFAULT NULL
) | 
+-------+--------------------------------------------------+
1 row in set (0.01 sec)

mysql> create table t9 (s1 int) partition by list (s1) (partition p1 values in
    -> (1));
Query OK, 0 rows affected (0.01 sec)

mysql> show create table t9\G
*************************** 1. row ***************************
       Table: t9
Create Table: CREATE TABLE `t9` (
  `s1` int(11) DEFAULT NULL
) PARTITION BY LIST (s1) (PARTITION p1 VALUES IN (1) ENGINE = MyISAM)
1 row in set (0.00 sec)
[13 Jun 2006 12:25] Mikael Ronström
Patch will appear in 5.1.12
[14 Jun 2006 1:23] Jon Stephens
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented bugfix in 5.1.12 changelog. Closed.