Bug #57410 "No changes to object were detected." when removing unique colum index
Submitted: 12 Oct 2010 18:20 Modified: 12 Nov 2010 21:13
Reporter: Rob Magee Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.28 OS:Windows (Windows 2008 Server)
Assigned to: CPU Architecture:Any
Tags: changes, Drop, unique

[12 Oct 2010 18:20] Rob Magee 
Description:
Right click on existing table with a column that contains a unique index- my table happened to already have data in it.  Unclicking the index results in a "No changes to object were detected.
SQL:" and the table remains unchanged when the Apply button is clicked. 

How to repeat:
Create table with a unique index on a non-key column.
Put some data in table.
Right click on table in sql editor and choose "Alter Table"
Under the colums tab, unclick the "UQ" check box and click "Apply"
[12 Oct 2010 21:13] MySQL Verification Team 
Thank you for the bug report. Could you please try version 5.2.29.
[13 Nov 2010 0: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".