MySQL Bugs: #49048: Table options don't allow clearing drop-down

Bug #49048	Table options don't allow clearing drop-down
Submitted:	24 Nov 2009 18:15	Modified:	8 Dec 2009 11:39
Reporter:	Todd Farmer (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.2 r4753	OS:	Windows (XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
Using the WB table creation wizard, once certain table options are selected, there is no way to remove them, because the drop-down is constrained to possible values (and no "no value" option).

For example, I clicked in the "Merge Method" option to see the various options.  It now makes me choose between No Insert, Last Table and First Table.  That's no good; if I've decided to use InnoDB instead of MERGE, the resulting CREATE TABLE script will not work:

CREATE  TABLE IF NOT EXISTS `test`.`new_table` (

  `idnew_table` INT NOT NULL ,

  PRIMARY KEY (`idnew_table`) )

ENGINE = InnoDB

INSERT_METHOD = NO

ROW_FORMAT = DEFAULT;

How to repeat:
Use create table wizard, select table options from drop-down, then try to eliminate these options.

Suggested fix:
Add "no value" or blank option which may be selected at any time.

Fixed in 5.2 (the "Prevent Inserts" option for merge tables does no longer add an "INSERT_METHOD NO" entry, instead nothing is inserted).

Also the other two options are fixed in 5.2.

option "Don't use" has been added to the dropdowns for the table-options "pack keys", "row format" and "merge method" on table editors options tab.

will be included in 5.2.11

An entry has been added to the 5.2.11 changelog:

When using the Create Table wizard in the SQL Editor, the resulting dialog contained certain options that could not be deselected once selected. For example, the Merge Method option featured a drop down list with three options: Prevent Inserts, First Table, Last Table. Note that once one of these options was selected, there was no way to clear this selection, as there was no facility to select anything other than one of these three options.