MySQL Bugs: #53063: CREATE INDEX lowercasing table name

Bug #53063	CREATE INDEX lowercasing table name
Submitted:	22 Apr 2010 13:40	Modified:	22 May 2010 16:07
Reporter:	Steve Gansemer	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S3 (Non-critical)
Version:	5.1.45	OS:	MacOS
Assigned to:		CPU Architecture:	Any

Description:
If I create a table with an uppercase table name, and then use CREATE INDEX to create an index on a column on the table, the table then shows up as lowercase.  However, if I use ALTER TABLE ADD INDEX instead of CREATE INDEX, the table remains uppercase.

How to repeat:
CREATE TABLE SOME_TABLE

(Display table in SQL tool will show SOME_TABLE)

CREATE INDEX ANINDEX ON SOME_TABLE(SOME_COLUMN);

(Display table in SQL tool will show some_table)

Sorry, but I can't repeat this:

77-52-4-109:5.1 openxs$ bin/mysql -uroot test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.47-debug Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create table SOME_TABLE(c1 int);
Query OK, 0 rows affected (0.05 sec)

mysql> show create table SOME_TABLE\G
*************************** 1. row ***************************
       Table: SOME_TABLE
Create Table: CREATE TABLE `SOME_TABLE` (
  `c1` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql> create index SOME_INDEX on SOME_TABLE(c1);
Query OK, 0 rows affected (0.07 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> show create table SOME_TABLE\G
*************************** 1. row ***************************
       Table: SOME_TABLE
Create Table: CREATE TABLE `SOME_TABLE` (
  `c1` int(11) DEFAULT NULL,
  KEY `SOME_INDEX` (`c1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.01 sec)

mysql> exit
Bye
77-52-4-109:5.1 openxs$ uname -a
Darwin 77-52-251-37.dialup.umc.net.ua 9.6.0 Darwin Kernel Version 9.6.0: Mon Nov 24 17:37:00 PST 2008; root:xnu-1228.9.59~1/RELEASE_I386 i386

So, please, send your my.cnf file content and exact test case.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".