Bug #54471 Alter Table Foreign Key tab/Foreign Key Optins -> Index: INVALID

Description:
When the "Alter Table" dialog on an InnoDb table is brought up in an SQL Editor session and you click on a foreign key in the foreign keys tab, the Foreign Key Options Index shows "INVALID".

How to repeat:
Open the "Alter table" dialog in the SQL Editor on a table with foreign keys.
If you click on any foreign key the Index in "Foreign Key Options" shows up as INVALID.
If I update any index on the Index tab, all the foreign key indexes show up correctly.

Another thing I noticed is that when creating a foreign key (MySQL 5.1.47) an index of that name is also created on the Indexes tab but no storage type is given when you click on the index.

Should foreign key indexes be assigned an index type?

Thank you for the bug report. Verified just as described on Windows XP.

Removed misleading INVALID marked in FK index field

What you did is fine, there is no index type set by default for the FK index because it's left to be set by default by the server.

fix confirmed in release 5.2.27

An entry has been added to the 5.2.27 changelog:

When the Alter Table dialog on an InnoDB table was displayed in an SQL Editor session, the Foreign Key Options Index showed INVALID, when a foreign key in the Foreign Keys tab was clicked.