diff options
| author | unknown <monty@narttu.mysql.fi> | 2003-08-29 04:17:58 +0300 |
|---|---|---|
| committer | unknown <monty@narttu.mysql.fi> | 2003-08-29 04:17:58 +0300 |
| commit | c1d4c15a2776fa788a0f3ecf9478844f4f57615f (patch) | |
| tree | 10581a216ef4e33affb4c03545c8687fef708228 /mysql-test/t | |
| parent | f1d3304e54a38aae7568794be7c1ecd86db988c7 (diff) | |
| parent | acc42602cdad41dd33ef9acf335d23de5f12ffe9 (diff) | |
| download | mariadb-git-c1d4c15a2776fa788a0f3ecf9478844f4f57615f.tar.gz | |
Merge bk-internal.mysql.com:/home/bk/mysql-4.0
into narttu.mysql.fi:/my/mysql-4.0
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/lowercase_table.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/lowercase_table.test b/mysql-test/t/lowercase_table.test index 397cc26e127..86ea2918fd2 100644 --- a/mysql-test/t/lowercase_table.test +++ b/mysql-test/t/lowercase_table.test @@ -6,6 +6,10 @@ drop table if exists t1,t2,t3; create table T1 (id int primary key, Word varchar(40) not null, Index(Word)); INSERT INTO T1 VALUES (1, 'a'), (2, 'b'), (3, 'c'); SELECT * FROM t1; +SELECT T1.id from T1 LIMIT 1; +SELECT T2.id from t1 as T2 LIMIT 1; +--error 1109 +SELECT T2.id from t1 as t2 LIMIT 1; RENAME TABLE T1 TO T2; ALTER TABLE T2 ADD new_col int not null; ALTER TABLE T2 RENAME T3; @@ -18,6 +22,7 @@ drop table t3; create table t1 (a int); select count(*) from T1; select count(*) from t1; +--error 1109 select count(T1.a) from t1; --error 1109 select count(bags.a) from t1 as Bags; |