MySQL Bugs: #66309: Alter table does not show order of fields in foreign key or index used

Bug #66309	Alter table does not show order of fields in foreign key or index used
Submitted:	10 Aug 2012 15:50	Modified:	10 Aug 2012 17:10
Reporter:	Bob Dankert	Email Updates:
Status:	Won't Fix	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.41	OS:	Windows (W7 32/64)
Assigned to:		CPU Architecture:	Any
Tags:	ALTER TABLE, Froeign key, INDEX, order

Description:
The order of fields in a foreign key is not shown when altering the table.  It also does not show the index that is being used by the foreign key.  These are two pieces of information that can be helpful in certain situations.

How to repeat:
Create a multi-field foreign key, go in and look at it in the editor.  It doesn't show the order of the fields in the FK and it doesn't show which index is being used by the FK.

Suggested fix:
Show the order of the fields in the FK similarly to how they are shown for an index.  Also show the index being used by the FK.

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.