diff options
Diffstat (limited to 'mysql-test/t/lowercase_table.test')
| -rw-r--r-- | mysql-test/t/lowercase_table.test | 28 |
1 files changed, 18 insertions, 10 deletions
diff --git a/mysql-test/t/lowercase_table.test b/mysql-test/t/lowercase_table.test index bdfa8dfc132..602a05a7848 100644 --- a/mysql-test/t/lowercase_table.test +++ b/mysql-test/t/lowercase_table.test @@ -4,6 +4,7 @@ --disable_warnings drop table if exists t1,t2,t3,t4; +drop database if exists mysqltest; --enable_warnings create table T1 (id int primary key, Word varchar(40) not null, Index(Word)); @@ -32,6 +33,23 @@ select count(bags.a) from t1 as Bags; drop table t1; # +# Test all caps database name +# +create database mysqltest; +use MYSQLTEST; +create table t1 (a int); +select T1.a from MYSQLTEST.T1; +--error 1109 +select t1.a from MYSQLTEST.T1; +select mysqltest.t1.* from MYSQLTEST.t1; +select MYSQLTEST.t1.* from MYSQLTEST.t1; +select MYSQLTEST.T1.* from MYSQLTEST.T1; +select MYSQLTEST.T1.* from T1; +alter table t1 rename to T1; +select MYSQLTEST.t1.* from MYSQLTEST.t1; +drop database mysqltest; + +# # multiupdate/delete & --lower-case-table-names # create table t1 (a int); @@ -54,13 +72,3 @@ select C.a, c.a from t1 c, t2 C; drop table t1, t2; show tables; - -# -# Test all caps database name -# -create table t1 (a int); -select TEST.t1.* from TEST.t1; -alter table t1 rename to T1; -select TEST.t1.* from TEST.t1; -drop table t1; - |