diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2017-07-17 22:34:07 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2017-07-17 22:34:07 +0200 |
| commit | b461e34c68709a720ec45825d492dbf690241dc4 (patch) | |
| tree | b4c102f440298aaa44a1ad36986a393099284a46 /mysql-test/t | |
| parent | 27bc13b7a2f99a6011a5081670b320c685dde443 (diff) | |
| download | mariadb-git-bb-5.5-MDEV-11240.tar.gz | |
MDEV-11240: Server crashes in check_view_single_update or Assertion `derived->table' failed in mysql_derived_merge_for_insertbb-5.5-MDEV-11240
Move table pointer for single table view (even if it is view over other view) to make the access universal.
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/view.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index aece2000cd4..659327eebb1 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -5565,6 +5565,22 @@ select * drop view v1; drop table t1,t2,t3; +--echo # +--echo # MDEV-11240: Server crashes in check_view_single_update or +--echo # Assertion `derived->table' failed in mysql_derived_merge_for_insert +--echo # + +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; +drop view v1,v2; +drop table t3; + --echo # ----------------------------------------------------------------- --echo # -- End of 5.5 tests. --echo # ----------------------------------------------------------------- |