Bug #48364 Can't create a table with ENUM column
Submitted: 28 Oct 2009 8:40 Modified: 29 Oct 2009 4:51
Reporter: Susanne Ebrecht Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2 OS:Linux (Ubuntu)
Assigned to: CPU Architecture:Any

[28 Oct 2009 8:40] Susanne Ebrecht 
Description:
1) Open Workbench 5.2
2) New Model
3) Add Diagram
4) Place a table and double click it to
5) Columns
6) e enum()

Always when you click outside the data type field the data type enum() will be changed to INT.

If you try first to add an INT column and want your second column to be ENUM then it always switch back to VARCHAR.

How to repeat:
See above
[29 Oct 2009 4:51] Alfredo Kojima 
ENUM() is not a valid type specification, you need to give some value to it. I've tried ENUM('a','b','c') and it worked.