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: | |
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
[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.