summaryrefslogtreecommitdiff
path: root/mysql-test/r/view.result
diff options
context:
space:
mode:
authorunknown <msvensson@neptunus.(none)>2005-09-14 08:10:18 +0200
committerunknown <msvensson@neptunus.(none)>2005-09-14 08:10:18 +0200
commitee4b49698d71cc8a4cfc385ea54d4e16bbeed507 (patch)
tree02ddcdefa369e441d63902b28d298501876765e2 /mysql-test/r/view.result
parentc8fcc511103f45e8f463f63cf0891e2db1dbabd0 (diff)
parent74b5120554269afb6e892f4766a25a9f5ed47fe1 (diff)
downloadmariadb-git-ee4b49698d71cc8a4cfc385ea54d4e16bbeed507.tar.gz
Merge bk-internal.mysql.com:/home/bk/mysql-5.0
into neptunus.(none):/home/msvensson/mysql/bug10713_new/my50-bug10713_new mysql-test/r/mysqldump.result: Auto merged mysql-test/r/view.result: Auto merged mysql-test/t/mysqldump.test: Auto merged sql/item.cc: Auto merged sql/sql_show.cc: Auto merged sql/table.h: Auto merged
Diffstat (limited to 'mysql-test/r/view.result')
-rw-r--r--mysql-test/r/view.result6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result
index 5572292c68e..258130d1e85 100644
--- a/mysql-test/r/view.result
+++ b/mysql-test/r/view.result
@@ -2190,3 +2190,9 @@ create table t1 (s1 int);
create view abc as select * from t1 as abc;
drop table t1;
drop view abc;
+create table t1(f1 char(1));
+create view v1 as select * from t1;
+select * from (select f1 as f2 from v1) v where v.f2='a';
+f2
+drop view v1;
+drop table t1;