diff options
| author | Alexander Barkov <bar@mariadb.org> | 2016-05-23 16:25:51 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2016-05-23 16:25:51 +0400 |
| commit | 9a25c01f7848324dd63c64ea4e1c86ef1cebfbc8 (patch) | |
| tree | 96550047ad79ecee87fb0e694ccb2a043746a6db /mysql-test/r/view.result | |
| parent | 4c0e2960d458cb437d4aa06d9193f5576c027448 (diff) | |
| download | mariadb-git-9a25c01f7848324dd63c64ea4e1c86ef1cebfbc8.tar.gz | |
MDEV-10102 Disallow CREATE VIEW .. PROCEDURE ANALYSE() syntactically
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 3fccd6e54c2..ca1a1dfa48a 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -923,12 +923,12 @@ select * from v4; ERROR 21000: Subquery returns more than 1 row drop view v4, v3, v2, v1; create view v1 as select 5 into @w; -ERROR HY000: View's SELECT contains a 'INTO' clause +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'into @w' at line 1 create view v1 as select 5 into outfile 'ttt'; -ERROR HY000: View's SELECT contains a 'INTO' clause +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'into outfile 'ttt'' at line 1 create table t1 (a int); create view v1 as select a from t1 procedure analyse(); -ERROR HY000: View's SELECT contains a 'PROCEDURE' clause +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'procedure analyse()' at line 1 create view v1 as select 1 from (select 1) as d1; ERROR HY000: View's SELECT contains a subquery in the FROM clause drop table t1; |