diff options
author | unknown <bell@sanja.is.com.ua> | 2004-11-24 19:48:30 +0200 |
---|---|---|
committer | unknown <bell@sanja.is.com.ua> | 2004-11-24 19:48:30 +0200 |
commit | c774eb0e6d6ded18d8dabf0c718a4313780cbd24 (patch) | |
tree | 61a65160b16c22bd0c4d702f207e3436be702557 /mysql-test/t/lowercase_view.test | |
parent | f39d77fdfc9175b233de8e3e03080fc8217a8b1b (diff) | |
download | mariadb-git-c774eb0e6d6ded18d8dabf0c718a4313780cbd24.tar.gz |
fixed problem in MacOS
correct printing of aliases
mysql-test/r/lowercase_view.result:
aliases in VIEWs
mysql-test/t/lowercase_view.test:
aliases in VIEWs
sql/item.cc:
tracking using aliases in indentifiers
sql/item.h:
tracking using aliases in indentifiers
sql/sql_base.cc:
tracking using aliases in indentifiers
sql/sql_lex.cc:
tracking using aliases in indentifiers
sql/sql_lex.h:
tracking using aliases in indentifiers
sql/table.h:
tracking using aliases in indentifiers
Diffstat (limited to 'mysql-test/t/lowercase_view.test')
-rw-r--r-- | mysql-test/t/lowercase_view.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/lowercase_view.test b/mysql-test/t/lowercase_view.test index 2a2757650ae..4b688cfb922 100644 --- a/mysql-test/t/lowercase_view.test +++ b/mysql-test/t/lowercase_view.test @@ -32,3 +32,18 @@ delete from v2aA where col1 = (select max(col1) from v1aA); insert into v2aA values ((select max(col1) from v1aA)); drop view v2Aa,v1Aa; drop table t1Aa,t2Aa; + +# +# aliases in VIEWs +# +create table t1Aa (col1 int); +create view v1Aa as select col1 from t1Aa as AaA; +show create view v1AA; +drop view v1AA; +select Aaa.col1 from t1Aa as AaA; +create view v1Aa as select Aaa.col1 from t1Aa as AaA; +drop view v1AA; +create view v1Aa as select AaA.col1 from t1Aa as AaA; +show create view v1AA; +drop view v1AA; +drop table t1Aa; |