MySQL Bugs: #38652: Failure to drop foreign key index

Bug #38652	Failure to drop foreign key index
Submitted:	8 Aug 2008 2:39	Modified:	28 May 2009 12:47
Reporter:	Aleksey Grichenko	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Dropping a foreign key index fails with error 1025 - 'Error on rename...'.
If deleting the foreign key itself, everything works fine.

How to repeat:
1. Create table t1 with an integer primary key `id`.
2. Create table t2, add aolumns a (primary key) and b (integer, not null).
3. Add foreign key for b, referencing t1.id.
4. Apply changes.
5. Edit table t2, switch to the 'Indicies' tab.
6. Select the foreign key index and delete it (click '-').
7. Apply changes. Fail.

Suggested fix:
At least: disable deleting FK index, warn to delete the FK instead.

Thank you for a problem report. As you indeed can not drop index needed for a foreign key while the key is declared, I'd say this is a reasonable feature request for MYSQL Administrator.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. We won't add this feature request anymore.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/