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:
None 
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 Oct 2009 10:01] Jorge Hernández
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
[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.

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

Page generated in 0.054 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.