MySQL Bugs: #46906: Relationship cardinality change from previous edit is copied upon double click.

Bug #46906	Relationship cardinality change from previous edit is copied upon double click.
Submitted:	24 Aug 2009 23:44	Modified:	20 Apr 2010 15:25
Reporter:	Chris Van Vranken	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	5.1.17 (Rev. 4302)	OS:	Windows
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	cardinality, relationship

Description:
In the EER diagram of workbench if one changes the cardinality of a relationship and then immediately edits a second relationship the cardinality of the first relationship is applied to the second relationship.

This makes it easy to apply changes to a large number of relationships, however it is a behavior I did not expect and could cause someone to accidentally change a relationship they didn't intend to and not even realize it.

How to repeat:
In the EER Diagram. Double click on a relationship between two tables and then choose the Foreign Key tab.  Change the cardinality for the relationship, for instance change it from one-to-many to one-to-one.  Now immediately double click on another one-to-many relationship. 

The new relationship will change to one-to-one as well.

This happens with changes from one-to-many to one-to-one and vice-versa.

Suggested fix:
When one double clicks on a new relationship after editing the cardinality of another relationship it should simply display the properties of the new relationship instead of applying changes from the first relationship.

If one wishes to edit multiple relationships they should select them individually and change them individually, or they should select all of the ones they want to change and then change all of the selected relationships at once.

Thank you for the bug report.

I am unable to repeat this in latest version, this has probably been fixed previously.

behaves correctly in current repository version

An entry has been added to the 5.2.19 changelog:

In the EER Diagram view, if the cardinality of a relationship was changed and then an attempt made to edit a second relationship, the cardinality of the first relationship was applied to the second relationship.