MySQL Bugs: #35093: Changing foreign key name in key editor doesn't change table definition

Bug #35093	Changing foreign key name in key editor doesn't change table definition
Submitted:	6 Mar 2008 0:10	Modified:	15 Mar 2008 12:53
Reporter:	Tim Lokot	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.0.14	OS:	Windows (XP (SP2))
Assigned to:		CPU Architecture:	Any
Tags:	foreign key

Description:
If I edit a foreign key and change the name, the name change isn't reflected in the tables it is joined to.

How to repeat:
1. Create two tables on the EER canvas
2. Setup a 1:n non-identifying relationship between the two tables

The name should have been automatically allocated to the foreign key at this stage.

3. Rename the table at the "1" end of the 1:n relationship
4. Double click the foreign key line to open the foreign key editor and change its name
5. Double click the table at the "n" end of the 1:n relationship
6. Click the "Foreign Keys" tab and the name listed there should be the old name, not the new name

Suggested fix:
I was expecting the name change to have propagated through to the other table.

Thank you for a bug report. Verified just as described.

this isn't a bug. Only the initial value of the "Caption" of a relationship-figure is taken from the FK-name, but you're free to change that caption without influencing the FK_name. If you want to change the name of the foreign key you have to do this in the table editors "Foreign Keys"-Tab.

A note has been added to the 5.15 changelog: 

When changing the name within a foreign key relationship, the modified name is not reflected in the tables to which the foreign key is related.