Bug #19750 relationship tool displays duplicate relationships
Submitted: 12 May 2006 4:03 Modified: 12 May 2006 7:37
Reporter: Steve Baker Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Preview Severity:S3 (Non-critical)
Version:1.0.6-1 beta OS:Linux (linux)
Assigned to: CPU Architecture:Any

[12 May 2006 4:03] Steve Baker
Description:
When you create relationships between tables (1:1, 1:n and n:m) the first relationship is created and displayed correctly. Each additional relationship will also be displayed and created correctly, however the visual elements for all existing relationships will be duplicated. Every time you repeat this, additional visual entities for each existing relationship will be duplicated, so for complex databases you end up with tens of relationships displayed between each table.

How to repeat:
**** setup ****
Create a new workspace, and add 3 tables - leave their default names. 
Add a primary key for each table (i.e. id1, id2 and id3). 
Click on any of the three relationship tools from the left menu.
Click on table_1, to create the start point for the relationship.
Click on table_2, to create the end point for the relationship.
FKTable_1 will be created successfully.
**** issue starts here *****
Click on any of the three relationship tools from the left menu.
Click on table_2, to create the start point for the relationship.
Click on table_3, to create the end point for the relationship.
FKTable_2 will be created successfully.
An additional FKTable_1 will be displayed, so there is two FKTable_1's displayed on the workspace.
If you check the table information, there is only 1 FK relationship set up between Table_1 and Table_2.
If you delete one of the FKTable_1 relationships, one of the two visual links will be removed, and the actual FK relationship will be removed. The second visual link will remain, and you are unable to remove it via any method.

Suggested fix:
Check the FK drawing logic - see what is triggering the second (and third, etc) draw of this key.
[12 May 2006 6:26] Steve Baker
Just confirmed this error is reproducable on the Windows 1.0.6-beta as well.
[12 May 2006 7:37] MySQL Verification Team
Duplicate for http://bugs.mysql.com/bug.php?id=19315