summaryrefslogtreecommitdiff
path: root/mysql-test/t/view.test
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2017-03-08 12:11:49 +0100
committerOleksandr Byelkin <sanja@mariadb.com>2017-03-08 12:11:49 +0100
commit0b1abc2f0f391d4e55029fa53f1e5da926f7be61 (patch)
tree46ec764b45873bd8ee9a0502804543b6ca42015e /mysql-test/t/view.test
parent8c3b98fe5aa8482ffa67e1e38354f5e98113e3ef (diff)
downloadmariadb-git-0b1abc2f0f391d4e55029fa53f1e5da926f7be61.tar.gz
MDEV-10704: Assertion `field->field->table == table_arg' failed in fill_record(THD*, TABLE*, List<Item>&, List<Item>&, bool, bool)
the bug test suite
Diffstat (limited to 'mysql-test/t/view.test')
-rw-r--r--mysql-test/t/view.test17
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test
index 3475d325321..e5dd22c64c3 100644
--- a/mysql-test/t/view.test
+++ b/mysql-test/t/view.test
@@ -6071,5 +6071,22 @@ drop view v1;
drop table t1;
--echo #
+--echo # MDEV-10704: Assertion `field->field->table == table_arg'
+--echo # failed in fill_record(THD*, TABLE*, List<Item>&, List<Item>&,
+--echo # bool, bool)
+--echo #
+
+CREATE TABLE t1 (i INT);
+CREATE TABLE t2 (j INT);
+CREATE TABLE t3 (k INT);
+
+CREATE ALGORITHM = MERGE VIEW v AS SELECT j AS f1, k AS f2 FROM ( SELECT j FROM t1, t2 ) sq, t3;
+--error ER_VIEW_MULTIUPDATE
+REPLACE INTO v (f1,f2) VALUES (1,1);
+
+drop view v;
+drop table t1,t2,t3;
+
+--echo #
--echo # End of 10.2 tests
--echo #