Bug #70051 When addign foreign keys, creates superfluous indices
Submitted: 15 Aug 2013 14:44 Modified: 15 Sep 2013 14:58
Reporter: Victor Porton Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.40 OS:Any
Assigned to: CPU Architecture:Any

[15 Aug 2013 14:44] Victor Porton
Description:
When adding a foreign key for an already indexed field, it nevertheless creates a new index which duplicated the existing index for the field.

It should not happen.

How to repeat:
Create a field. Add index to this field. Add a foreign key for this field.

Suggested fix:
Use the existing index when available.
[15 Aug 2013 14:58] Alfredo Kojima
Please try 6.0.6
[16 Sep 2013 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".