Bug #33139 Workbench is crashing on save after changing foreign key column
Submitted: 11 Dec 2007 13:25 Modified: 15 Feb 2008 22:21
Reporter: laurent melmoux Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.10 OS:Windows (XP SP2)
Assigned to: Johannes Taxacher CPU Architecture:Any
Tags: crash, foreign key

[11 Dec 2007 13:25] laurent melmoux 
Description:
In diagram mode with 2 tables with foreign key referencing:

When I change the foreign key column the diagram doesn’t redraw (red colour on the foreign key) and Workbench is crashing when I try to save the MWB file.

How to repeat:
1) Add 2 tables :

table1
-------------------
table1_id (INT)
table2_id (INT)

table2
-------------------
table2_id (INT)

2) Add a 1:n non identifying relationship 
The foreign key table2_id1 (red colour on schema) is added to table1

3) On table1 > foreign key tab
Uncheck table2_id1 and Check table2_id

table2_id1 is still red on the schema should be table2_id

4) Save 
Workbench crash
[11 Dec 2007 17:33] MySQL Verification Team 
Thank you for the bug report.
[8 Jan 2008 12:14] Johannes Taxacher 
- Crash is fixed in 5.0.11 Rev 2381 (therefore I'm changing severity to S3).
- But canvas update (as described) is still not working. The red diamond changes correctly in columnlist on the column-tab in the table-editor, but not on the canvas ... when model is reloaded it is displayed correctly.
[11 Feb 2008 17:54] Alfredo Kojima 
canvas update was fixed
[15 Feb 2008 15:26] Johannes Taxacher 
fixed in 5.0.13 SVN Rev 2574
[15 Feb 2008 22:21] Peter Lavin 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.
Added to the changelog.