Bug #30902 MySQL Workbench - Foreign Key Label Issues
Submitted: 7 Sep 2007 15:29 Modified: 11 May 2008 0:31
Reporter: Spencer Crissman Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.11, 1.1.10 alpha OS:Any
Assigned to: Alfredo Kojima CPU Architecture:Any
Triage: D3 (Medium)

[7 Sep 2007 15:29] Spencer Crissman
Two issues with foreign key label display in Workbench:

1) Foreign key labels cannot be hidden.

2) Foreign key labels are not centered, instead their left edge is aligned with the center of the relationship line.

The combination of these issues lead to unwieldy graphs, when tables are placed close together.

How to repeat:
1) Create a schema in workbench.
2) Create two tables.
3) Create a foreign key relationship between the two tables.
4) Move the tables close together, such that the distance between the two tables on the graph is just barely larger than the length of the fk label itself, and such that the tops of the tables are aligned.
5) Note that the fk label now overlaps the left edge of the table on the right, and that there is no way to remove the label.

Suggested fix:
Add one feature and one fix:
Feature: Allow user to toggle whether the fk label is displayed for a given relationship.

Fix: Truly center foreign key labels, so that overlap only occurs if the distance between the tables is actually smaller than the label length.
[7 Sep 2007 18:07] Valeriy Kravchuk
Thank you for a problem report. Verified just as described on XP.
[30 Jan 2008 23:06] Alfredo Kojima
An option to hide all connection captions globally has been added.
[8 Apr 2008 15:14] Alfredo Kojima
Added an option to center captions
[8 Apr 2008 21:58] Johannes Taxacher
fixed as commented by developer (tested SVN Rev 3011)
[11 May 2008 0:31] Paul Dubois
Noted in 5.0.18 changelog.

Foreign key labels could not be hidden, and displayed labels were not
centered. There are now options to hide all connection captions, and
to center captions.