| Bug #48288 | Inserts-Editor doesn't let me introduce values in enum fields | ||
|---|---|---|---|
| Submitted: | 25 Oct 2009 10:01 | Modified: | 26 Nov 2009 17:08 |
| Reporter: | Jorge Hernández | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 5.1.18 | OS: | Linux (Ubuntu 9.04 i386) |
| Assigned to: | Sergei Tkachenko | CPU Architecture: | Any |
| Tags: | enum, Inserts_Editor | ||
[25 Nov 2009 12:14]
Johannes Taxacher
fixed in repository. will be included in version 5.2.9 note that inserts editor doesn't validate entered data if they are correct enum values. this is planned for a later major version of WB
[26 Nov 2009 17:08]
Tony Bedford
An entry has been added to the 5.2.9 changelog: The Inserts Editor did not display columns of type ENUM.
Description: The Inserts Editor doesn't show the enum columns. When completing the other fields and closing the editor, the program fills the enum fields in the INSERT call with a NULL or an empty How to repeat: Create a table with some colums and set one of them ENUM,(i.e. ENUM('A','B')). In the "Inserts" tab, click "Open Editor". See that it doesn't show the enum column. Fill one row. Close the Editor. Depending on the position of the enum columns into the table, it will appear a NULL or an empty in the respective field of the call. Suggested fix: It would be nice to be able to write the value by hand, but it would be even nicer being able to choose it in a dropdown