Bug #38545 Relationship connectors get lost

• Submitted: 4 Aug 2008 16:28
• Modified: 19 Jun 2009 10:13
• Reporter: Alex Saavedra
• Status: Closed
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.0.30
• OS: Windows
• CPU Architecture: Any
• Tags: CHECKED

[4 Aug 2008 16:28] Alex Saavedra

Description:
When you show the same relationships in various EER diagrams, at some point they disappear and don't show up anymore.

How to repeat:
1. open the attached .mwb project
2. notice the "Company" EER diagram, which lacks relationship connections between tblCompany, tblCompanyPhone, tblCompanyEmail and tblCompanyAddress
3. notice the "Customer" EER diagram showing above mentioned relationships correctly.
4. if you erase "Company" EER diagram and try to recreate a new one showing up existing relationships between tblCompany, tblCompanyPhone, tblCompanyEmail and tblCompanyAddress, they won't show up
5. if you erase _all_ EER Diagrams from MySQL Model main page, and recreate a brand new EER Diagram for tblCompany, tblCompanyPhone, tblCompanyEmail and tblCompanyAddress, they will show up correctly

[4 Aug 2008 16:29] Alex Saavedra

EER Diagrams with various relationships

Attachment: test.mwb (application/x-zip-compressed, text), 65.68 KiB.

[4 Aug 2008 20:19] MySQL Verification Team

Thank you for the bug report.

[26 Feb 2009 13:44] Susanne Ebrecht

This needs re-verfiying with Workbench 5.0.30

[11 Mar 2009 17:50] Susanne Ebrecht

I can't repeat this anymore with MySQL Workbench 5.0.30. Please try actual version 5.0.30.

[11 Mar 2009 19:39] Alex Saavedra

I repeated the procedure with v 5.0.30. I could see the relationships appear upon following this procedure:

1. open the attached file
2. create a new EER diagram, and drag tblCompany + tblCompanyEmail tables (no relationships appear)
3. erase the recently created EER diagram
4. create a new EER diagram, and drag tblCompany + tblCompanyEmail tables  (no relationships appear)
5. erase the recently created EER diagram
6. create a new EER diagram, and drag tblCompany + tblCompanyEmail tables. This time, relationships will show up correctly

This seems to be insensitive to whether you save the file or not.

[12 Mar 2009 11:07] Susanne Ebrecht

Ok, I got it

1) Open Workbench SE
2) Open .mwb file that is given here
3) Add a Diagram
4) MySQL Model, Table section, choose all tables that start with tblCompany ...
5) drag all and copy them into the new EER diagram

Some conditions will be drawn others not.

You also can drag/copy table by table into the new diagram it will have same effect.

When you cut all tables that not start with tblCompany and then try Model -> Create Diagram from catalog objects all conditions will be drawn correct

[17 Jun 2009 8:32] Johannes Taxacher

this has been fixed in Workbench 5.1.13.

[19 Jun 2009 10:13] Tony Bedford

An entry was added to the 5.1.13 changelog:

When tables with relationship connectors were dragged or copied from one EER diagram to another, the connectors were not always drawn.