Bug #76359 Drop-down lists for enum fields
Submitted: 17 Mar 2015 19:26 Modified: 3 Feb 2018 11:27
Reporter: John Deery Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:6.3.10 OS:Any
Assigned to: CPU Architecture:Any

[17 Mar 2015 19:26] John Deery
This is a carry over of request 30455 for MySQL Query Browser:

Mysql Workbench is a great tool in that I can let it in the hands of non technical people.  To be cautious, I implement a few restrictions so that these operators can do no harm: limited privileges, a few triggers, and enums() where possible.

The only problem is that the operator needs to know the different enum() strings and type them without typo.  For anything other than enum('yes','no') this just doesn't work in practice.

How to repeat:
create a table with an enum with 20 non trivial values (for instance account numbers) and have an operator try to change the value twenty times to any one of these values without error.

Suggested fix:
Having a drop-down-choose-from list (like an HTML <SELECT>) for enum fields would be a _tremendeous_ improvement in the GUI.
[19 Mar 2015 14:53] John Deery
Picture of what I think the change could look like

Attachment: enum_proposal.jpg (image/jpeg, text), 208.13 KiB.

[3 Feb 2018 11:27] MySQL Verification Team
Hello John Deery,

Thank you for the feature request!