MySQL Bugs: #19695: Partitions: ignoring no_table

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

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)

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)

Patch will appear in 5.1.12

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.