Bug #63961 Can't create UNIQUE index on multiple columns

• Submitted: 7 Jan 2012 23:48
• Modified: 8 Feb 2012 17:07
• Reporter: Sébastien Alfaiate
• Status: No Feedback
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 5.2.37
• OS: Windows
• CPU Architecture: Any
• Tags: unique

[7 Jan 2012 23:48] Sébastien Alfaiate

Description:
It is impossible to create UNIQUE indexes on multiple columns.

How to repeat:
When i alter an existing table, go to the "Indexes" tab.

Create a new entry. Choose "UNIQUE".

I can't check columns i want. The primary key i checked by default and I can't uncheck it or check others columns.

[7 Jan 2012 23:53] Sébastien Alfaiate

I just found a way to bypass this problem :

After creating the new entry and select "UNIQUE". Click on another index then re-click on the unique index you just create. And now, it's ok, you can check what you want...

[8 Jan 2012 17:07] Valeriy Kravchuk

What exact server version, 5.x.y, are you working with? I can not repeat this with my tables on 5.1.61, so exact CREATE TABLE for the table you try to add UNIQUE index for will be also useful.

[9 Feb 2012 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".