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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.