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

Bug #54471	Alter Table Foreign Key tab/Foreign Key Optins -> Index: INVALID
Submitted:	13 Jun 2010 18:39	Modified:	29 Sep 2010 16:26
Reporter:	John David	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.22.OSS.RC	OS:	Any
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

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.