MySQL Bugs: #40649: Renaming a Foreign Key clears its Referenced Columns

Bug #40649	Renaming a Foreign Key clears its Referenced Columns
Submitted:	11 Nov 2008 19:49	Modified:	8 Dec 2008 17:12
Reporter:	Witek Radomski	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.0.27	OS:	Windows
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
A foreign key's Referenced Columns become cleared if the foreign key is renamed. Trying to choose a Referenced Column right after this happens does not show a link in the EER Diagram view. Only after removing checkmarks from Columns and re-checking them (and then choosing the Referenced Columns) does the foreign key relationship work properly again.

How to repeat:
Having a foreign key relationship, double click on a table in the EER Diagram view and click the Foreign Keys tab. Double click the name of the foreign key in the Foreign Key Name column to rename it, and type a new name. Hit Enter twice or click away. The Referenced Column at the right loses its reference.

Thank you for a bug report. Verified as described.

renaming now doesn't affect the link anymore, 
but changing the refernced table, empties the referenced column  - which is correct  - when i then try to assign a new referenced column (without removing the check on the column) the connection line isn't added to the canvas. only unchecking and re-checking the column adds the connection correctly again

confirm fixed. will be in 5.0.28

An entry was added to the 5.0.28 changelog:

The Referenced Column pane of the Foreign Key tab became cleared if the foreign key was renamed. Subsequently, attempting to choose a Referenced Column did not display a link in the EER Diagram view. In order to get foreign key relationships working again it was necessary to de-select the checkboxes from the Columns pane, re-select them, and then select the Referenced Column pane.