diff options
author | Oleksandr Byelkin <sanja@mariadb.com> | 2017-08-16 19:18:39 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2017-08-17 11:41:46 +0200 |
commit | c548fb0667ffe71d9387eaec342b1716fc4c9526 (patch) | |
tree | eef086b1f25e0065b43b5b578581b2fa1e27ee8b /mysql-test | |
parent | cb1e76e4de120d20064a96be4fcc245c3d22bd78 (diff) | |
download | mariadb-git-c548fb0667ffe71d9387eaec342b1716fc4c9526.tar.gz |
MDEV-11240: Server crashes in check_view_single_update or Assertion `derived->table' failed in mysql_derived_merge_for_insertmariadb-10.2.8
Before "merge" view shoud be inited to maintaing transitive attributes like "multitable".
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/view.result | 3 | ||||
-rw-r--r-- | mysql-test/t/view.test | 5 |
2 files changed, 1 insertions, 7 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index b5e4d5423d6..81cc41e5ab3 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -5674,9 +5674,6 @@ CREATE TABLE t3 (a INT); CREATE ALGORITHM = MERGE VIEW v1 AS SELECT t2.a FROM t3 AS t1, t3 AS t2; CREATE ALGORITHM = MERGE VIEW v2 AS SELECT * FROM v1; PREPARE stmt FROM 'REPLACE INTO v2 SELECT a FROM t3'; -EXECUTE stmt; -ERROR HY000: Can not insert into join view 'test.v2' without fields list -EXECUTE stmt; ERROR HY000: Can not insert into join view 'test.v2' without fields list drop view v1,v2; drop table t3; diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index d5e5a51e8da..de7edd158e5 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -5577,11 +5577,8 @@ drop table t1,t2,t3; CREATE TABLE t3 (a INT); CREATE ALGORITHM = MERGE VIEW v1 AS SELECT t2.a FROM t3 AS t1, t3 AS t2; CREATE ALGORITHM = MERGE VIEW v2 AS SELECT * FROM v1; -PREPARE stmt FROM 'REPLACE INTO v2 SELECT a FROM t3'; ---error ER_VIEW_NO_INSERT_FIELD_LIST -EXECUTE stmt; --error ER_VIEW_NO_INSERT_FIELD_LIST -EXECUTE stmt; +PREPARE stmt FROM 'REPLACE INTO v2 SELECT a FROM t3'; drop view v1,v2; drop table t3; |