| Bug #48288 | Inserts-Editor doesn't let me introduce values in enum fields | ||
|---|---|---|---|
| Submitted: | 25 Oct 11:01 | Modified: | 26 Nov 18:08 |
| Reporter: | Jorge Hernández | ||
| Status: | Closed | ||
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 5.1.18 | OS: | Linux (Ubuntu 9.04 i386) |
| Assigned to: | Sergei Tkachenko | Target Version: | WB52 |
| Tags: | Inserts_Editor, enum | ||
[25 Nov 13: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 18: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