MySQL Bugs: #45626: Can't Delete Indexes in Table Editor

Bug #45626	Can't Delete Indexes in Table Editor
Submitted:	19 Jun 2009 19:03	Modified:	1 Jul 2009 19:07
Reporter:	Justin Noel	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.1.14 RC	OS:	MacOS (4 GB , 2.8 Ghz)
Assigned to:		CPU Architecture:	Any
Tags:	CHECKED, delete, INDEX, remove

Description:
FYI : I just upgaded to 5.1.14 RC.  I had this same version in the prior RC, but didn't get around to submitting ticket...

I cannot delete indexes from a table once they are defined.  The Edit->Delete option does not exist.  The Command-Backspace (or Delete) keyboard shortcuts do not work.  Their is NO context menu when right clicking on an index.

Also, I cannot delete columns from a table with keyboard shortcuts or the Edit->Delete options.  I can only delete them by right clicking a column and selecting "Delete Selected Columns".

How to repeat:
Create a table in Workbench.  Add a few columns.

Click on the Indices tab.  Add an index for a column.  Try to delete it. You can't via any means.

Now, try to undo the addtion by : Edit->Undo Add Index .....   It doesn't work.

Now, press Command - Z to undo the index addition.  This works.

Suggested fix:
Correct so that Command and Delete (Backspace) on the Mac delete columns AND indices.

Add a right click context menu to indices.

Thank you for the bug report.

Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/

We fixed this as part of the WB 5.1.16 GA release.