summaryrefslogtreecommitdiff
path: root/mysql-test/r/view.result
diff options
context:
space:
mode:
authorunknown <sergefp@mysql.com>2005-08-03 03:47:07 +0000
committerunknown <sergefp@mysql.com>2005-08-03 03:47:07 +0000
commite442059c0dbfeadaabf7e12e905fec0b94c153a6 (patch)
tree551d1a44fe7c14ba73b87378e84fb04d7228ab30 /mysql-test/r/view.result
parent88105618c5eba3714189875a8d799cb7503bd657 (diff)
parentb323667ffc7176482073ca7d626560dcd8d7ee75 (diff)
downloadmariadb-git-e442059c0dbfeadaabf7e12e905fec0b94c153a6.tar.gz
Manual merge
mysql-test/r/sp.result: Auto merged mysql-test/r/view.result: Auto merged mysql-test/t/view.test: Auto merged sql/item_func.cc: Auto merged sql/sp.cc: Auto merged sql/sp_head.cc: Auto merged sql/sp_head.h: Auto merged sql/sql_base.cc: Auto merged sql/sql_class.cc: Auto merged sql/sql_class.h: Auto merged sql/sql_lex.cc: Auto merged sql/sql_parse.cc: Auto merged sql/sql_trigger.h: Auto merged
Diffstat (limited to 'mysql-test/r/view.result')
-rw-r--r--mysql-test/r/view.result5
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result
index 730e180cbd9..062c1ac6a8a 100644
--- a/mysql-test/r/view.result
+++ b/mysql-test/r/view.result
@@ -581,6 +581,11 @@ ERROR HY000: View 'test.v1' references invalid table(s) or column(s) or function
drop view v1;
create view v1 (a,a) as select 'a','a';
ERROR 42S21: Duplicate column name 'a'
+drop procedure if exists p1;
+create procedure p1 () begin declare v int; create view v1 as select v; end;//
+call p1();
+ERROR HY000: View's SELECT contains a variable or parameter
+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;