Bug #33408 Crash during opening of a mwb file
Submitted: 20 Dec 2007 15:54 Modified: 9 Jan 2008 10:09
Reporter: moi meme Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S1 (Critical)
Version:5.0.11b OS:Windows (XP)
Assigned to: CPU Architecture:Any
Tags: open mwb, relationship

[20 Dec 2007 15:54] moi meme
Impossible relationship crashes MySQL workbench

How to repeat:
First, relationships seems to be buggy when linked:
Create a table 'A' with a key 'Ak'
Create a table 'B' with a key 'Bk'
Create a table 'C' with a key 'Ck'
Declare a relationship between A and B, foreign key 'Bak' is created in B
Declare a relationship between B and C, foreign keys 'Cbk' and 'Cbak' are created in C (why the foreign key 'Bak' of B is considered has a real key ?!)
Delete 'Cbak' (foreign key of C linked with foreign key of B linked with key of A...)
Try to delete relationship between B and C ... impossible
After many trials, workbench crashes and write on my mwb file wich is now impossible to open... :(

Suggested fix:
Don't consider foreign keys has keys when creating a relation.
[20 Dec 2007 19:01] MySQL Verification Team
Thank you for the bug report.
[8 Jan 2008 16:59] Johannes Taxacher
the posted MWB-file opens flawlessly in 5.0.11 and I can't reproduce the problem regarding the keys.
could you try with the latest version if the problem still exists for you and if, maybe you could post your A-B-C-example-file?
[9 Jan 2008 9:45] moi meme
I can't reproduce the problem on the 5.0.11b version.