MySQL Bugs: #10260: Setting up Foreign Key

Bug #10260	Setting up Foreign Key
Submitted:	29 Apr 2005 12:07	Modified:	4 Oct 2005 13:41
Reporter:	Sandu Cristian	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	1.0.20	OS:	Windows (Windows XP SP2)
Assigned to:		CPU Architecture:	Any

Description:
I have several tables and I create a new table. I had defined the name and the data type of the fields and I apply the changes. Then, without closing the window, I set-up the foreign key for a field. Then i've noticed that I misstyped the field name and I corect it. Then I change the field name for the foreign key to the new one and I click "Apply Changes" and an error pop's up with MySQL Error number: 1005. Can't Create table ".\table_name\#sql-564_8c.frm" (errno: 121). 

I have tried the process 8 times until I desided to post the bug.

I hope it helps.

How to repeat:
I tried to apply the changes to the field name before creating any foreign key but when I create the foreign key (without closing the window) it gives me the same error. It does'n take the new field name into consideration. It remains with the old field name into memory. 

But if you close the "create table" window and reopen it then the error message does not appear anymore.

Dupli of bug http://bugs.mysql.com/bug.php?id=13741
and not Administrator bug.