MySQL Bugs: #39511: Can't rename a foreign key (by renaming index)

Bug #39511	Can't rename a foreign key (by renaming index)
Submitted:	18 Sep 2008 8:33	Modified:	5 Aug 2009 14:51
Reporter:	Fabien Haddadi	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.0.25	OS:	Windows
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	CHECKED

Description:
From the foreign keys tab, I can't rename a foreign key from fk_categorie_categorie to categorie_ibfk1

How to repeat:
- load the mwb that you ask me to attach (how?)

- try to rename the foreign key specified

Thank you for the report.

Please click "Files" tab, then follow instructions how to attach a file.

I reformulate :

MySQL WB doesn't want to rename from the Indexes tab, but is ok if we rename the foreign key through the Foreign key tab.

I suggest that we are not offered the option to rename from the Indexes tab if we can't do it.

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

I too exp this problem in 5.0.29.  Very annoying.  Any idea when it will be fixed?

I have changed the behavior to allow renaming foreign keys by renaming it's corresponding index.
The FK name will be automatically updated when the index is renamed. The index name will also be
updated when the FK name is changed.

the fix/change will be included in 5.1.17

note for docs: please add the information that its now possible to rename a "FOREIGN" index with the effect of WB changing the FK name accordingly.

A 'change' entry has been added to the 5.1.17 changelog:

In the Foreign Keys tab it was not possible to rename a foreign key by renaming the corresponding index entry.

MySQL Workbench has been changed so that it is possible to rename a foreign key by renaming its corresponding index. The foreign key name is now automatically updated when the index is renamed. The index name is also updated when the foreign key name is changed.