diff options
Diffstat (limited to 'mysql-test/r/lowercase_table.result')
| -rw-r--r-- | mysql-test/r/lowercase_table.result | 12 |
1 files changed, 4 insertions, 8 deletions
diff --git a/mysql-test/r/lowercase_table.result b/mysql-test/r/lowercase_table.result index dc8fffa0f90..f0cb4cc3ccf 100644 --- a/mysql-test/r/lowercase_table.result +++ b/mysql-test/r/lowercase_table.result @@ -45,10 +45,11 @@ count(bags.a) drop table t1; create database mysqltest; use MYSQLTEST; +create table t1 (a int); select T1.a from MYSQLTEST.T1; a select t1.a from MYSQLTEST.T1; -Unknown table 't1' in field list +a select mysqltest.t1.* from MYSQLTEST.t1; a select MYSQLTEST.t1.* from MYSQLTEST.t1; @@ -59,7 +60,9 @@ select MYSQLTEST.T1.* from T1; a alter table t1 rename to T1; select MYSQLTEST.t1.* from MYSQLTEST.t1; +a drop database mysqltest; +use test; create table t1 (a int); create table t2 (a int); delete p1.*,P2.* from t1 as p1, t2 as p2 where p1.a=P2.a; @@ -76,10 +79,3 @@ ERROR 42000: Not unique table/alias: 'C' drop table t1, t2; show tables; Tables_in_test -create table t1 (a int); -select TEST.t1.* from TEST.t1; -a -alter table t1 rename to T1; -select TEST.t1.* from TEST.t1; -a -drop table t1; |