diff options
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 16 |
1 files changed, 13 insertions, 3 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 2a593f7c6df..5f399b816ac 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -977,9 +977,19 @@ ERROR HY000: View 'test.v1' references invalid table(s) or column(s) drop view v1; create view v1 (a,a) as select 'a','a'; ERROR 42S21: Duplicate column name 'a' -create procedure p11 () begin declare v int; create view v1 as select v; end;// +create procedure p1 () begin declare v int; create view v1 as select v; end;// Warnings: Warning 1310 Referring to uninitialized variable v -call p11(); +call p1(); ERROR HY000: View's SELECT contains a variable or parameter -drop procedure p11; +drop procedure p1; +create table t1 (col1 int,col2 char(22)); +insert into t1 values(5,'Hello, world of views'); +create view v1 as select * from t1; +create view v2 as select * from v1; +update v2 set col2='Hello, view world'; +select * from t1; +col1 col2 +5 Hello, view world +drop view v2, v1; +drop table t1; |