MySQL Bugs: #68234: Unable to name or correctly create indexes on new or existing tables

Bug #68234	Unable to name or correctly create indexes on new or existing tables
Submitted:	31 Jan 2013 12:03	Modified:	6 Feb 2013 9:36
Reporter:	Mike Hancock	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.2.45	OS:	MacOS
Assigned to:		CPU Architecture:	Any
Tags:	index creation, index editing, table creation, table editing

Description:
I am unable to create or edit indexes on new or existing tables without the editor messing up the index name during SQL generation.

The editor also make it difficult to use the column checkboxes and the index type dropdown then the cursor is in the index name text area.

Index names that are successfully entered still come out as automatically named indicies when clicking apply.

Current workaround is to copy the SQL, rename the indexes and execute manually (or write the whole thing manually).

How to repeat:
Create or alter a table using the editor in Workbench. Switch to the indicies tab and write the name of a new index. Select checkboxes.

You will have difficulty keeping the index name entered in the text area and when submitting the changes the index name will be "index1" etc rather than the name specified.

Suggested fix:
This previously worked (for certain in 5.2.43). Please examine code changes since that version.

Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=68103 .

This appears to have been fixed in version 5.2.46 (although not apparent in the release notes of said version).