MySQL Bugs: #33408: Crash during opening of a mwb file

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:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	5.0.11b	OS:	Windows (XP)
Assigned to:		CPU Architecture:	Any
Tags:	open mwb, relationship

Description:
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.

Thank you for the bug report.

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?

I can't reproduce the problem on the 5.0.11b version.