Bug #18762 upper/lowercase inconsistent table name sensitivity between operating systems.

• Submitted: 3 Apr 2006 22:40
• Modified: 4 Apr 2006 9:15
• Reporter: Darl Kuhn
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0
• OS: Linux (Linux)
• CPU Architecture: Any

[3 Apr 2006 22:40] Darl Kuhn

Description:
On a Windows XP server, MySQL version 5.0.18-nt, I can create a table as following:

mysql> create table MY_TAB(my_tab varchar(30));

I can then do:

mysql> desc my_tab;
or
mysql> desc MY_TAB;

But when I move my scripts to a Linux server, MySQL version 5.0.19-standard, I do the same thing:

mysql> create table MY_TAB(my_tab varchar(30));

I cannot do this now:

mysql> desc my_tab;

I can only do:

mysql> desc MY_TAB;

It would be nice if the table name case sensitivity didn't change from one OS to another. Becauase now I have to change all of my create table scripts on the Linux box, because all of my "create view" statements subsequently fail because they reference the lowercase of the table name. For example, this won't work for me in my Linux environment:

mysql> create view my_view as select * from my_tab;

Whereas the above works fine in my Windows environment.

Here's the Linux version I'm using:

uname -a

Linux ora-as3 2.4.21-32.0.1.EL #1 Tue May 17 18:01:37 EDT 2005 i686 i686 i386 GNU/Linux

How to repeat:
See description.

Suggested fix:
I can change my create table scripts or my create view scripts.

[4 Apr 2006 9:15] Hartmut Holzgraefe

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

http://dev.mysql.com/doc/refman/5.0/en/name-case-sensitivity.html