Bug #37215 Truncate enum values for diagrams
Submitted: 5 Jun 2008 6:05 Modified: 29 Jul 2009 13:55
Reporter: Lars Monecke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.0, 5.1 OS:Windows (XP 64)
Assigned to: CPU Architecture:Any
Tags: CHECKED

[5 Jun 2008 6:05] Lars Monecke
Description:
We use the datatype enum with a large list of values. This looks very ugly in the diagrams. Our workarround is toturn off the options "show table column types", but than we see no data type :-(

How to repeat:
create a colum with data type 'enum('foobar1','foobar2','foobar3','foobar4','foobar5','foobar6','foobar7')

Suggested fix:
add a option like "trim routines names longer than xxx"
[6 Jun 2008 3:16] Valeriy Kravchuk
Thank you for a reasonable feature request.
[27 Aug 2008 12:26] Lars Monecke
We need this feature very urgent. Is there a planend version or time when this feature is implemented?

BTW: IMHO this is a bug not a feature...
[15 May 2009 10:58] Susanne Ebrecht
Tested with Workbench 5.1:

enum('foobar1','foobar2','foobar3','foobar4','foobar5','foobar6','foobar7')

still will be displayed just in one row and not very nice trimed let us say into 9 rows. Or just into two or three rows.
[29 Jul 2009 13:55] Alfredo Kojima
This has been fixed, 5.1.16 does not present this behaviour.
Now, besides being able to reduce the width of tables by hand, which will truncate
the ENUM type visualization, you can specify a max size for ENUMs and SETs.
If the max size is passed, the ENUM will not be displayed.