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/r/lowercase_view.result | |
| 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/r/lowercase_view.result')
| -rw-r--r-- | mysql-test/r/lowercase_view.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/lowercase_view.result b/mysql-test/r/lowercase_view.result index 64b40389690..0644b32015c 100644 --- a/mysql-test/r/lowercase_view.result +++ b/mysql-test/r/lowercase_view.result @@ -22,3 +22,19 @@ insert into v2aA values ((select max(col1) from v1aA)); ERROR HY000: You can't specify target table 'v2aa' for update in FROM clause drop view v2Aa,v1Aa; drop table t1Aa,t2Aa; +create table t1Aa (col1 int); +create view v1Aa as select col1 from t1Aa as AaA; +show create view v1AA; +View Create View +v1aa CREATE ALGORITHM=UNDEFINED VIEW `test`.`v1aa` AS select `aaa`.`col1` AS `col1` from `test`.`t1aa` `AaA` +drop view v1AA; +select Aaa.col1 from t1Aa as AaA; +col1 +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; +View Create View +v1aa CREATE ALGORITHM=UNDEFINED VIEW `test`.`v1aa` AS select `aaa`.`col1` AS `col1` from `test`.`t1aa` `AaA` +drop view v1AA; +drop table t1Aa; |