Bug #68103 Unable to create indices
Submitted: 16 Jan 2013 22:15 Modified: 13 Jun 2013 1:14
Reporter: Christian Ungur Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:5.2.45 OS:MacOS (10.6.8)
Assigned to: CPU Architecture:Any
Tags: INDEX, indexes, Indices

[16 Jan 2013 22:15] Christian Ungur
Description:
I'm unable to create indices on a newly or already existent table.

How to repeat:
Create new model. Create new ERR-Diagramm. Place a new Table onto diagramm. Create 'idCol'. Create a second col 'someCol' of indiferent datatype. Switch to Indices-View and try to add a new custom index through double click on <click to edit>...
[16 Jan 2013 22:15] Christian Ungur
Indices-View

Attachment: Bildschirmfoto 2013-01-16 um 23.10.59.png (image/png, text), 57.00 KiB.

[18 Jan 2013 10:48] Christian Ungur
This bug becomes really critical to me.

It is not possible to manipulate indices at all...

1.) I cannot rename automatically created indices (for instance indices from ForeignKeys or indices created from column-attribute Unique)
2.) When I'm creating complex ForeignKey-References Workbench automatically creates indices for every ForeigKey-Relation which is ok, but for multiple foreignkey relationships workbench creates redundant indices sometimes which in my opinion can be removed.
3.) It's not possible to change column order in automatically created indices (from foreign key relationships)
[18 Jan 2013 10:53] Christian Ungur
My Previous description was not complete. Sorry for that. Please ignore the previous list and  refer to the following one.

1.) I cannot rename automatically created indices (for instance indices from ForeignKeys or indices created from column-attribute unique). Also it is not possible to create custom indices instead, or at least to name/rename them (from the standard name 'index{sequence-num}').
2.) When I'm creating complex ForeignKey-References Workbench automatically creates indices for every ForeigKey-Relation which is ok, but for multiple foreignkey relationships workbench creates redundant indices sometimes which, in my opinion, can be removed but is not possible to remove them manually.
3.) It's not possible to change column order in automatically created indices (from foreign key relationships)
[21 Jan 2013 11:17] MySQL Verification Team
Thank you for the bug report.
[31 Jan 2013 19:49] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=68234 duplicate of this one.
[13 Jun 2013 1:14] Philip Olson
Fixed as of the upcoming MySQL Workbench 6.0.2 public beta release, and here's the changelog entry:

It was not possible to edit indexes in the index tab of the "EER
diagram", "Alter Table" window.

Thank you for the bug report.