diff options
Diffstat (limited to 'mysql-test/t/lowercase_table.test')
| -rw-r--r-- | mysql-test/t/lowercase_table.test | 17 |
1 files changed, 12 insertions, 5 deletions
diff --git a/mysql-test/t/lowercase_table.test b/mysql-test/t/lowercase_table.test index d52c60baea7..1b431a9d920 100644 --- a/mysql-test/t/lowercase_table.test +++ b/mysql-test/t/lowercase_table.test @@ -3,6 +3,7 @@ # drop table if exists t1,t2,t3,t4,T1; +drop database if exists mysqltest; create table T1 (id int primary key, Word varchar(40) not null, Index(Word)); create table t4 (id int primary key, Word varchar(40) not null); INSERT INTO T1 VALUES (1, 'a'), (2, 'b'), (3, 'c'); @@ -34,10 +35,16 @@ drop table t1; # # Test all caps database name # -create database foo; -use foo; +create database mysqltest; +use MYSQLTEST; create table t1 (a int); -select FOO.t1.* from FOO.t1; +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 FOO.t1.* from FOO.t1; -drop database FOO; +select MYSQLTEST.t1.* from MYSQLTEST.t1; +drop database mysqltest; |