# # Test of force of lower-case-table-names=0 # (User has case insensitive file system and wants to preserve case of # table names) # --source include/have_innodb.inc --source include/have_lowercase0.inc --source include/not_windows.inc --disable_warnings DROP TABLE IF EXISTS t1,T1; --enable_warnings # # This is actually an error, but ok as the user has forced this # by using --lower-case-table-names=0 CREATE TABLE t1 (a int); SELECT * from T1; drop table t1; flush tables; # # InnoDB should in this case be case sensitive # Note that this is not true on windows as no this OS, InnoDB is always # storing things in lower case. # CREATE TABLE t1 (a int) ENGINE=INNODB; --error 1146 SELECT * from T1; drop table t1; # End of 4.1 tests