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/suite/funcs_1 | |
| parent | 4c0e2960d458cb437d4aa06d9193f5576c027448 (diff) | |
| download | mariadb-git-9a25c01f7848324dd63c64ea4e1c86ef1cebfbc8.tar.gz | |
MDEV-10102 Disallow CREATE VIEW .. PROCEDURE ANALYSE() syntactically
Diffstat (limited to 'mysql-test/suite/funcs_1')
| -rw-r--r-- | mysql-test/suite/funcs_1/r/innodb_views.result | 2 | ||||
| -rw-r--r-- | mysql-test/suite/funcs_1/r/memory_views.result | 2 | ||||
| -rw-r--r-- | mysql-test/suite/funcs_1/views/views_master.inc | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/suite/funcs_1/r/innodb_views.result b/mysql-test/suite/funcs_1/r/innodb_views.result index 59eec5b0220..45de9534df2 100644 --- a/mysql-test/suite/funcs_1/r/innodb_views.result +++ b/mysql-test/suite/funcs_1/r/innodb_views.result @@ -3497,7 +3497,7 @@ DROP VIEW IF EXISTS v2 ; CREATE TABLE t1 (f1 BIGINT) ; SET @x=0; CREATE or REPLACE VIEW v1 AS Select 1 INTO @x; -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 @x' at line 1 Select @x; @x 0 diff --git a/mysql-test/suite/funcs_1/r/memory_views.result b/mysql-test/suite/funcs_1/r/memory_views.result index 995787aba84..ab4e2a9933c 100644 --- a/mysql-test/suite/funcs_1/r/memory_views.result +++ b/mysql-test/suite/funcs_1/r/memory_views.result @@ -3498,7 +3498,7 @@ DROP VIEW IF EXISTS v2 ; CREATE TABLE t1 (f1 BIGINT) ; SET @x=0; CREATE or REPLACE VIEW v1 AS Select 1 INTO @x; -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 @x' at line 1 Select @x; @x 0 diff --git a/mysql-test/suite/funcs_1/views/views_master.inc b/mysql-test/suite/funcs_1/views/views_master.inc index bb9bbdb06d0..f55788de6c6 100644 --- a/mysql-test/suite/funcs_1/views/views_master.inc +++ b/mysql-test/suite/funcs_1/views/views_master.inc @@ -266,7 +266,7 @@ CREATE TABLE t1 (f1 BIGINT) ; # SELECT INTO is illegal SET @x=0; ---error ER_VIEW_SELECT_CLAUSE +--error ER_PARSE_ERROR CREATE or REPLACE VIEW v1 AS Select 1 INTO @x; Select @x; |