MySQL Bugs: #58223: Cannot alter/edit table with mixed case name

Bug #58223	Cannot alter/edit table with mixed case name
Submitted:	16 Nov 2010 9:15	Modified:	29 Nov 2010 16:28
Reporter:	Peter Stibrany	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.2.29	OS:	MacOS (10.6.5)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
Right-click on table name and selecting "Alter table..." doesn't work on tables that have mixed-case names. It works on tables that have lowercase names though.

How to repeat:
Open connection to database, expand list of tables, right-click on table with mixed-case name (e.g. "Account" or "Company", maybe you will need to create such table first), and select "Alter Table...".

Expected: alter/edit table dialog opens.

Observed: nothing happens, no error, no dialog, nothing.

Repeating same steps on table like "fileinfo" or "indexjob" works just fine, and it opens the dialog.

This has been fixed recently and was caused by a bug in the MySQL server.

What mysql version do I need? I'm using 5.1.50 at the moment.

Peter, there is server where this is fixed if you don't want to install beta software. Simply wait for the next WB release which is around the corner.

I wanted to say "there is no server...".

fix confirmed in repository

An entry has been added to the 5.2.31 changelog:

In the SQL Editor, right-clicking on a table name and selecting Alter table did not launch the Alter table dialog as expected. This happened if the table name utilized mixed case letters.