Bug #4974 case sensitive select
Submitted: 10 Aug 2004 14:35 Modified: 10 Aug 2004 17:02
Reporter: Andrei Todea Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.20 Max OS:Linux (Linux (RH 9))
Assigned to: Dean Ellis CPU Architecture:Any

[10 Aug 2004 14:35] Andrei Todea 
Description:
Table names seem to be case sensitive although column names are case insensitive on the same server (MySQL 4.20 Max/RH Linux 9).

I tested with InnoDB and MyISAM table types.

How to repeat:
create table EMPLOYEE
(
   EMPNO                          int                            not null,
   FIRSTNAME                      varchar(50),
   LASTNAME                       varchar(50),
   primary key (EMPNO)
)
type = InnoDB;

INSERT INTO EMPLOYEE VALUES("1", "Andi", "Moeller");
INSERT INTO EMPLOYEE VALUES("2", "Oliver", "Kahn");
INSERT INTO EMPLOYEE VALUES("3", "Zinedine", "Zidane");

works (returns one record):
select * from EMPLOYEE where empno=2

doesn't work (doesn't return a record although there is one in the database):
select * from employee where empno=2
error: Table 'mdwork.employee' doesn't exist
[10 Aug 2004 17:02] Dean Ellis 
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:

This is expected behavior.  See: 

http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html