diff options
Diffstat (limited to 'mysql-test/r/lowercase_table.result')
| -rw-r--r-- | mysql-test/r/lowercase_table.result | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/mysql-test/r/lowercase_table.result b/mysql-test/r/lowercase_table.result index c884e5de0f0..8edf43a51ad 100644 --- a/mysql-test/r/lowercase_table.result +++ b/mysql-test/r/lowercase_table.result @@ -6,6 +6,14 @@ id Word 1 a 2 b 3 c +SELECT T1.id from T1 LIMIT 1; +id +1 +SELECT T2.id from t1 as T2 LIMIT 1; +id +1 +SELECT T2.id from t1 as t2 LIMIT 1; +Unknown table 'T2' in field list RENAME TABLE T1 TO T2; ALTER TABLE T2 ADD new_col int not null; ALTER TABLE T2 RENAME T3; @@ -21,8 +29,7 @@ select count(*) from t1; count(*) 0 select count(T1.a) from t1; -count(T1.a) -0 +Unknown table 'T1' in field list select count(bags.a) from t1 as Bags; Unknown table 'bags' in field list drop table t1; |