MySQL Bugs: #12496: table name case sensitive

Bug #12496	table name case sensitive
Submitted:	10 Aug 2005 14:07	Modified:	10 Aug 2005 14:42
Reporter:	Xiong He	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.10 beta	OS:	Linux (linux x86 standard version)
Assigned to:		CPU Architecture:	Any

Description:
The table name is case sensitive.
For example, I've created a table test(id int, name varchar(32)) in lower case.
In the last version, such as mysql4.*, 
When I called desc TEST, It's right.
But in mysql5.0.10beta, it's wrong.
desc TEST, it says that table TEST doesn't exist.

I've test that in mysql5.0.10 beta for winnt noninstall, no problem happens.

By the way, the 5.0.10beta standard version of mysql is downloaded from the website, without any install and make. Just run configure in Redhat7.2, glibc2.3
I have not download the source code to compile and make a version for 5.0.10beta.

How to repeat:
Install the mysql5.0.10beta for linux x86 standard version.
run ./configure
run ./mysqld or ./mysqld_safe
mysql -u root
create table TEST(id int);
desc test;
The wrong happenes, the hint is "table test doesn't exist"

Suggested fix:
Please fix the problem, the sooner the better.
5.0.6 version, I havn't test.
5.0.* for winnt ,there is no wrong.

Can u help me?

Hi! it's not a bug, in mysql tablenames depends on filenames. And if filesystem is case-sensitive (in unix for instance), the table names is case sensitive also.

you can read it more detailed about this problem (and workarounds) in the documentation: http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html