| Bug #45607 | datatype ENUM does not accept parenthesis in values | ||
|---|---|---|---|
| Submitted: | 19 Jun 2009 10:10 | Modified: | 1 Jul 2009 13:05 |
| Reporter: | Erkki Laaneoks | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S2 (Serious) |
| Version: | 5.0.30, 5.1.13 | OS: | Windows |
| Assigned to: | Alfredo Kojima | CPU Architecture: | Any |
| Tags: | CHECKED, enum | ||
[19 Jun 2009 11:46]
Valeriy Kravchuk
Thank you for the bug report. Verified just as described, with both 5.0.30 and 5.1.13.
[30 Jun 2009 19:06]
Johannes Taxacher
fixed in version 5.1.16
[1 Jul 2009 13:05]
Tony Bedford
An entry was added to the 5.1.16 changelog: The data type ENUM did not accept parenthesis in its values.
Description: I wanted add column, where datatype is: ENUM('Uus (tugev)','Uus (poolik)','Määratud (tegemata)','Määratud (sein)','tehtud (kalasadam)','Tehtud (lennujaam)','ei tea (taevane)','ei taha (tohutu)') But MySQL Workbench does not accept it. MySQL 5.0 database server accepted this column. How to repeat: Add under "Physical Schemata" new table and into it column where datatype is: ENUM('Uus (tugev)','Uus (poolik)','Määratud (tegemata)','Määratud (sein)','tehtud (kalasadam)','Tehtud (lennujaam)','ei tea (taevane)','ei taha (tohutu)') If I type datatype without parenthesis, then MySQL Workbench accept it: ENUM('Uus tugev','Uus poolik','Määratud tegemata','Määratud sein','tehtud kalasadam','Tehtud lennujaam','ei tea taevane','ei taha tohutu') Suggested fix: I think that problem is with parenthesis.