Bug #57143 Workbench - SQL - Alter table fails on index creation.
Submitted: 30 Sep 2010 13:53 Modified: 1 Oct 2010 13:27
Reporter: Kenneth Wagner Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:5.2.28 OS:Linux (Ubuntu Karmic 9.10)
Assigned to: CPU Architecture:Any
Tags: alter, Edit, table

[30 Sep 2010 13:53] Kenneth Wagner
Description:
Using Ubuntu AMD 64-bit Karmic Koala 9.10 with MWB 5.2.28 Ubuntu/Debian 64-bit for 9.10
Server is mysqld 5.1.37-1 Ubuntu 5.4

Using the Alter Table feature in SQL Development.

1. Works OK to change a column name.
2. Fails on new index creation:  ndx_long_desc (index name), long_desc (field name)  
3. In the bottom display window: No changes to object were detected. SQL: (no SQL shows)

No matter how the index is named and columns selected, no ALTER SQL is generated.

Thanks,

Ken Wagner

How to repeat:
Create a table then use ALTER TABLE to create a new index.

Suggested fix:
Fix coding.
[30 Sep 2010 16:11] MySQL Verification Team
Thank you for the bug report.
[1 Oct 2010 13:27] Alfredo Kojima
This is a duplicate of bug #56906