summaryrefslogtreecommitdiff
path: root/mysql-test/r/lowercase_table.result
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2004-09-02 16:57:26 +0300
committerunknown <monty@mysql.com>2004-09-02 16:57:26 +0300
commit167017935a8d8dc5cbe3d4c2fff267d14d4636d8 (patch)
treec8687c9c8877b4526e838a928b732b81f40f80ad /mysql-test/r/lowercase_table.result
parentc7d107254d2365f63dfb4fbd60232f93b1557a27 (diff)
downloadmariadb-git-167017935a8d8dc5cbe3d4c2fff267d14d4636d8.tar.gz
After merge fixes
mysql-test/mysql-test-run.sh: Export MASTER_MYSOCK (used in some tests) mysql-test/t/alter_table.test: Use MASTER_MYSOCK instead of master.sock
Diffstat (limited to 'mysql-test/r/lowercase_table.result')
-rw-r--r--mysql-test/r/lowercase_table.result12
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;