|
1
by brian
clean slate |
1 |
#
|
2 |
# Test of force of lower-case-table-names=0 |
|
3 |
# (User has case insensitive file system and wants to preserve case of |
|
4 |
# table names) |
|
5 |
#
|
|
6 |
||
7 |
--source include/have_innodb.inc
|
|
8 |
--source include/have_lowercase0.inc
|
|
9 |
--source include/not_windows.inc
|
|
10 |
||
11 |
--disable_warnings
|
|
12 |
DROP TABLE IF EXISTS t1,T1; |
|
13 |
--enable_warnings
|
|
14 |
||
15 |
#
|
|
16 |
# This is actually an error, but ok as the user has forced this |
|
17 |
# by using --lower-case-table-names=0 |
|
18 |
||
19 |
CREATE TABLE t1 (a int); |
|
20 |
SELECT * from T1; |
|
21 |
drop table t1; |
|
22 |
flush tables; |
|
23 |
||
24 |
#
|
|
25 |
# InnoDB should in this case be case sensitive |
|
26 |
# Note that this is not true on windows as no this OS, InnoDB is always |
|
27 |
# storing things in lower case. |
|
28 |
#
|
|
29 |
||
30 |
CREATE TABLE bug29839 (a int) ENGINE=INNODB; |
|
31 |
--error 1146
|
|
32 |
SELECT * from BUG29839; |
|
33 |
drop table bug29839; |
|
34 |
||
35 |
# End of 4.1 tests |