Bug #50854 Deleted relationship crashes Workbench
Submitted: 2 Feb 2010 20:21 Modified: 3 Feb 2010 14:39
Reporter: Cluesome McClue Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S1 (Critical)
Version:5.2.15a beta OS:MacOS (10.6.2)
Assigned to: CPU Architecture:Any
Tags: crash, delete, EER Diagram, modelling, relationship

[2 Feb 2010 20:21] Cluesome McClue
Description:
1. what I did:

In the EER Diagram tab I had previously created three relationships between table 'information' and three others: 'units', 'nutrition' and 'vitaminsminerals'.
I deleted the relationship between 'information' and 'units'. This seemed to cause the other two relationships to lose their connections and no longer 'point' to the pk in 'information'.
I double clicked the 'information' to 'nutrition' relationship to select it and right-clicked on it and selected the Delete option.
This seemed to have no effect so I selected the 'nutrition' table and in the table editor selected the Columns tab and right clicked on the 'informationID' foreign key column and selected the Delete Selected Columns option.

2. What I wanted to happen:

The relationship that had turned faulty would be deleted.

3. What actually happened:

Workbench crashed.

How to repeat:
Use the attached mwb file, select the EER Diagram tab and either double click on the relationship between 'nutrition' and 'information' tables, or try to delete the foreign key in the 'nutrition' table.
[2 Feb 2010 22:06] Cluesome McClue
this version has never been opened (and therefore not auto-fixed)

Attachment: neveropened.mwb (application/octet-stream, text), 14.57 KiB.

[2 Feb 2010 23:01] Cluesome McClue
It would seem that a workaround is to delete the links using the delete tool.
[3 Feb 2010 0:01] MySQL Verification Team
On Windows Vista I couldn't repeat probably Mac OS X specific.
[3 Feb 2010 4:47] Valeriy Kravchuk
I can not repeat this on Mac OS X 10.5.6.
[3 Feb 2010 8:21] Geert Vanderkelen
Opening the model files neveropened.mwb and show problem.mwb yielded following error messages (using 5.2.15a/Mac OSX 10.6.2):

The model in file '/Users/geert/Downloads/neveropened.mwb' contained problems which were successfully recovered:
 -Foreign Key fknutritioninformation1 has an invalid column definition. The invalid values were removed.
 -Foreign Key fkvitaminsmineralsinformation1 has an invalid column definition. The invalid values were removed.

Nobody else saw these?
[3 Feb 2010 8:27] Geert Vanderkelen
Maybe I'm not following the exact same steps, but I haven't noticed a crash yet.