Bug #76214 ENUM Datatype causes syntax error when creating or altering a table.

• Submitted: 9 Mar 2015 0:32
• Modified: 19 Mar 2015 4:58
• Reporter: Gregory Lundberg
• Status: Closed
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 6.3.1.0 build 404 (64 bits)
• OS: Linux (Ubuntu 14.10)
• CPU Architecture: Any
• Tags: regression, WBBugReporter

[9 Mar 2015 0:32] Gregory Lundberg

Description:
When entering a new column for a table the handling of ENUM() removes parentheses and quotes. The table cannot be altered or created with an enum datatype.

How to repeat:
Open Workbench 6.3.1.0, create a new Schema, create a new table ('new_table'), tab to start a new column ('new_tablecol') tab to Datatype, enter "enum('One','Two')", press tab.

Note the display for Datatype changes to "ENUMOne, Two" this error propagates to the CREATE TABLE or ALTER TABLE upon clicking Apply.

Suggested fix:
Backport working code from earlier versions.

Workaround: hand-edit the SQL to correct the syntax for the ENUM clause before submitting the CREATE TABLE or ALTER TABLE.

[9 Mar 2015 6:18] MySQL Verification Team

Hello Gregory Lundberg,

Thank you for the report.
Confirmed this issue with WB 6.3.1.0 build 404(64bits) on Win7.
WB 6.2.5 is not affected.

Thanks,
Umesh

[19 Mar 2015 4:58] Philip Olson

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.3 release, and here's the changelog entry:

While creating or altering a table, the ENUM type handler would remove
parentheses and quotes. For example, "enum('One','Two')" would convert to
"ENUMOne, Two". 

Workaround: Review and correct the SQL before submitting the CREATE TABLE or ALTER TABLE.

Thank you for the bug report.