MySQL Bugs: #26812: QB cannot edit tables whose table names contain a capital letter

Bug #26812	QB cannot edit tables whose table names contain a capital letter
Submitted:	2 Mar 2007 23:21	Modified:	12 Mar 2007 12:29
Reporter:	Brad Peterson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.10	OS:	Windows (Windows XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
Whenever I try to edit a table that begins with a capital letter, I get the following message:

A MySQL error was encountered. The message is:
Cannot fetch table information
The following error occurred: (0).

But if the table name begins with a lowercase letter, it works just fine.  I've tested this through numerous scenarios, using the same exact CREATE TABLE statement, except switching out the first character with a lower or uppercase one.  The lowercase ones are always work.  The uppercase ones always give me the error.

How to repeat:
Create a table with a with an uppercase letter with a first character.  For example:

CREATE TABLE `Issue_upper` (
  `UserId` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`UserId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Refresh the schema list to see the new table.  Right click on Issue_upper, click on "Edit Table".  You will see the error.

This error never happened on earlier versions.  I'm only seeing it happen on the version I'm running, version 1.2.10

Actually, any capital letter in the table name gives this problem.  Only lower case names work.

Thank you for a problem report. What version of MySQL server are you connecting to, and on what OS it runs? I can not repeat with 5.0.27 running (locally) on Windows XP, hence the questions.

I'm having this same problem.  I'm using the Windows XP version of the query browser, and the MySQL Ver 5.0.27 on linux, Fedora Core 3 to be exact.

Sorry, i thought I put the MySQL version number.  Version 5.0.27 on Linux

I have the same error with QB 1.2.10 on WinXP SP2 with MySQL 5.0.27 on linux (debian sarge).
 - The same error occurs also when a tablename has uppercase letters in the middle, like in 'tEST'.
 - The same error occurs also when renaming a table with the "Table Editor" from lowercase to uppercase. After showing the resulting statement like
ALTER TABLE `st_catalog`.`test` RENAME TO `st_catalog`.`Test`;
the same error occurs.
I never had this type of error in older versions of QB.

I have same problem with client on XP and server on Linux ::

Server Information
  MySQL Version:           MySQL 5.0.16-standard via TCP/IP
--------------------------------------------------------------------------------
Client Information
  Version:                 MySQL Client Version 5.1.11
  Operating System:        Windows XP

Verified just as described when working with 5.0.x on Linux having lower_case_table_names=0.

Any uppercase in TableName give "Cannot fetch table information"
Not only in QB but also in MySQL Administrator

I'm using windows Client on Unix Server:
- MSA  version 1.2.10
- MSQB version 1.2.10
- MySQL 4.1.21-standard

I reinstalled MSQB 1.1.20, the one I had been using, without removing V1.2.10 and used in same client/server without problem.

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html