MySQL Bugs: #35447: errors creating relationships

Bug #35447	errors creating relationships
Submitted:	19 Mar 2008 23:39	Modified:	28 Mar 2008 17:27
Reporter:	Xavier Irias	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.0.15	OS:	Windows (xp sp2)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	relationships

Description:
Sometimes but not always, a msgbox appears with an "index out of range" when placing a 1:n relation.  When this happens the foreign key is placed in the destination table but the relationship does not appear in the diagram.

Other times, a msgbox appeas with a "operation on NULL object: Invalid value" when placing the relation.  When this happens, relationship does not appear in the diagram, and the parent table (not the one receiving the foreign key) is no longer selectable until the file is closed and reopened.

How to repeat:
this bug was in 5.0.14 but is not 100% repeatable, which is why I had not reported it yet.

Suggested fix:
unknown

upgrading to serious since, at least with my file, the error is now repeatable and makes creation of new relations impossible.

Thank you for a bug report.

I'm guessing that the first error message "index out of range" resulted in some corruption within the file, and that's why any attempt to create a relationship now gives the error about the NULL object.  

Any chance the file can be repaired or will I have to recreate by hand?

Your model will work normally with the fixed version of WB.

great to hear. when will that be posted?

works in SVN Rev 2868

A note has been added to the 5.0.16rc changelog: 

When placing a 1:n relation, an index out of range error could be raised. This could further result in operation on NULL object: Invalid value errors when trying to edit the relation.