Bug #56613 Creating many-to-many relationship creates only one index

• Submitted: 7 Sep 2010 11:54
• Modified: 10 Nov 2010 13:49
• Reporter: Karsten Wutzke
• Status: Closed
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 5.2.26, 5.2.27
• OS: Any
• Assigned to: Alfredo Kojima
• CPU Architecture: Any
• Tags: indexes, many-to-many, regression

[7 Sep 2010 11:54] Karsten Wutzke

Description:
Creating a many-to-many relationship between two tables creates only one index.

How to repeat:
See attached model. Create an m:n relationship between Zips and Cities. Open the table view for the new table, the click the Indexes tab. There should be only one index. Since the new table has two foreign keys, it should have two indexes.

[26 Oct 2010 21:37] Alfredo Kojima

fixed

[27 Oct 2010 19:22] Karsten Wutzke

Which is the first WB version (release) that will include this fix?

[28 Oct 2010 14:59] Alfredo Kojima

Bug #56686 marked as a duplicate of this one

[28 Oct 2010 15:00] Alfredo Kojima

We cannot comment on when a specific bug fix will be included, but usually they appear on the following release.

[9 Nov 2010 10:30] Johannes Taxacher

fix confirmed in repository

[10 Nov 2010 13:49] Tony Bedford

An entry has been added to the 5.2.30 changelog:

Creating a many-to-many relationship between two tables resulted in only one index being generated.

[26 Nov 2010 13:39] Tony Bedford

Fix delayed to 5.2.31. Changelog updated accordingly.

[26 Nov 2010 13:39] Tony Bedford

Fix delayed to 5.2.31. Changelog updated accordingly.