diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2016-02-25 14:55:04 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2016-05-28 14:44:21 +0200 |
| commit | 7166069537a4e18d4c0848655fcbc0c8ee568fd4 (patch) | |
| tree | d07e24b3ce97d2b70583f3273eb1dfc4f438936e /mysql-test/t/sp-error.test | |
| parent | 1f89ea8ea049909228c441d125a2b13348ec56af (diff) | |
| download | mariadb-git-7166069537a4e18d4c0848655fcbc0c8ee568fd4.tar.gz | |
MDEV-3944: Allow derived tables in VIEWS
Diffstat (limited to 'mysql-test/t/sp-error.test')
| -rw-r--r-- | mysql-test/t/sp-error.test | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/t/sp-error.test b/mysql-test/t/sp-error.test index b1d4f67f357..15cd0ec4e81 100644 --- a/mysql-test/t/sp-error.test +++ b/mysql-test/t/sp-error.test @@ -1794,8 +1794,8 @@ CREATE PROCEDURE bug20953() CREATE VIEW v AS SELECT 1 INTO OUTFILE "file"; --error ER_PARSE_ERROR CREATE PROCEDURE bug20953() CREATE VIEW v AS SELECT i FROM t1 PROCEDURE ANALYSE(); ---error ER_VIEW_SELECT_DERIVED -CREATE PROCEDURE bug20953() CREATE VIEW v AS SELECT 1 FROM (SELECT 1) AS d1; +--error ER_PARSE_ERROR +CREATE PROCEDURE bug20953() CREATE VIEW v AS SELECT 1 FROM (SELECT 1) AS d1 into @w; --error ER_VIEW_SELECT_VARIABLE CREATE PROCEDURE bug20953(i INT) CREATE VIEW v AS SELECT i; delimiter |; |