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

[6 Mar 2008 0:10] Tim Lokot
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.
[6 Mar 2008 5:24] Valeriy Kravchuk
Thank you for a bug report. Verified just as described.
[7 Mar 2008 17:04] Johannes Taxacher
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.
[15 Mar 2008 12:53] MC Brown
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.