diff options
| author | unknown <monty@narttu.mysql.fi> | 2003-08-29 04:17:30 +0300 |
|---|---|---|
| committer | unknown <monty@narttu.mysql.fi> | 2003-08-29 04:17:30 +0300 |
| commit | 6d17d7f5bb27cc07706fb8e368eafbcc2b06fde9 (patch) | |
| tree | ed0ecfe13b9c732365bc16784e1209bf0847b8a4 /mysql-test/t/lowercase_table.test | |
| parent | 2db7d27f0e8b9f6e3ecbcee9345c5aff1db8e648 (diff) | |
| download | mariadb-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/t/lowercase_table.test')
| -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; |