Bug #46157 Cannot add/edit user defined types to workbench SE 5.1.16
Submitted: 13 Jul 2009 21:15 Modified: 13 Jul 2009 21:49
Reporter: Brian Sims Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.1.16 OS:Windows
Assigned to: CPU Architecture:Any
Tags: user types

[13 Jul 2009 21:15] Brian Sims 
Description:
Cannot add or edit an user type to the workbench.  This worked with version 5.0.30 SE.  I can find no way to work around this problem other than to not use it and define as normal types in all the tables in my database which will make updates much harder.

How to repeat:
If you go to Model, User Defined types... and open that window, then click the add button, usertype and INT(11) will be added at the bottom.  There is no way to edit the user type name or definition that I can find.  When you click apply, it is added to the user types tab in the catalog/layers/user types windows, but there is no way to edit it there either.  You can get the user type highlighted and type over it with your new variable name, but when you exit the field it reverts back to usertype.  Same problem with the definition field.  I did not test the flags field, so I don't know if it works or not.

Suggested fix:
Allow and save editing in fields.
[13 Jul 2009 21:16] Brian Sims 
screen shots of issue

Attachment: mysql workbench error in 5_1_16.doc (application/msword, text), 86.00 KiB.
[13 Jul 2009 21:46] Brian Sims 
Sorry, had typed in version 5.1.6 instead of 5.1.16
[13 Jul 2009 21:49] MySQL Verification Team 
Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=45936.