summaryrefslogtreecommitdiff
path: root/mysql-test/r/lowercase_table.result
diff options
context:
space:
mode:
authorunknown <monty@narttu.mysql.fi>2003-08-29 04:17:30 +0300
committerunknown <monty@narttu.mysql.fi>2003-08-29 04:17:30 +0300
commit6d17d7f5bb27cc07706fb8e368eafbcc2b06fde9 (patch)
treeed0ecfe13b9c732365bc16784e1209bf0847b8a4 /mysql-test/r/lowercase_table.result
parent2db7d27f0e8b9f6e3ecbcee9345c5aff1db8e648 (diff)
downloadmariadb-git-6d17d7f5bb27cc07706fb8e368eafbcc2b06fde9.tar.gz
Revert change of lower-case-table handling as this breaks how alias works.
Changes like this should be done to 4.1, not to a stable release mysql-test/r/lowercase_table.result: Revert change of lower-case-table handling mysql-test/t/lowercase_table.test: Revert change of lower-case-table handling sql/sql_class.cc: Revert change of lower-case-table handling sql/sql_class.h: Revert change of lower-case-table handling sql/sql_parse.cc: Revert change of lower-case-table handling sql/sql_table.cc: Revert change of lower-case-table handling sql/sql_yacc.yy: Revert change of lower-case-table handling
Diffstat (limited to 'mysql-test/r/lowercase_table.result')
-rw-r--r--mysql-test/r/lowercase_table.result11
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;