MySQL Bugs: #36112: Foreign Key caption name is fixed after Foreign Key creation

Bug #36112	Foreign Key caption name is fixed after Foreign Key creation
Submitted:	16 Apr 2008 6:13	Modified:	13 Jul 2013 3:38
Reporter:	Martin Gara	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Workbench	Severity:	S4 (Feature request)
Version:	5.0.17 OSS RC rev 2972	OS:	Windows (Win2K)
Assigned to:		CPU Architecture:	Any

Description:
Changing the name of a Foreign Key after it has been created does not change the foreign key relationship connection caption automatically. Tp change the caption you have to edit the connection directly.

How to repeat:
On an EER Diagram create a Foreign Key relationship between 2 tables.
Observe the caption value of the Foreign Key in the EER Diagram.
Change the Foreign Key Name in the Table Editor.
Observe that the caption value did not change.

Suggested fix:
Either provide an option that allows the caption to change when the Foreign Key Name changes - gloablly or as part of the Foreign Key options, or vice-versa.

caption and FK-name are two different properties for connections. The caption is only initially filled with the same value as the FK-name when the connection is created. That's the reason why the caption doesn't change when renaming FK.

An option to automatically sync those properties is a good idea imo so i'm setting this to "feature request". thanks for the input.

Relationship caption and FK name should not be used, one is meant to be user readable and the other is a MySQL identifier.