diff options
Diffstat (limited to 'mysql-test/t/lowercase_table.test')
| -rw-r--r-- | mysql-test/t/lowercase_table.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/lowercase_table.test b/mysql-test/t/lowercase_table.test index 2a3cc5b7e8f..2e5cb5f89fc 100644 --- a/mysql-test/t/lowercase_table.test +++ b/mysql-test/t/lowercase_table.test @@ -9,6 +9,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; |