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.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.052 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.
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.