[Commits] 0b1abc2: MDEV-10704: Assertion `field->field->table == table_arg' failed in fill_record(THD*, TABLE*, List<Item>&, List<Item>&, bool, bool)

Oleksandr Byelkin sanja at mariadb.com
Wed Mar 8 13:11:49 EET 2017


revision-id: 0b1abc2f0f391d4e55029fa53f1e5da926f7be61 (mariadb-10.2.4-27-g0b1abc2)
parent(s): 8c3b98fe5aa8482ffa67e1e38354f5e98113e3ef
committer: Oleksandr Byelkin
timestamp: 2017-03-08 12:11:49 +0100
message:

MDEV-10704: Assertion `field->field->table == table_arg' failed in fill_record(THD*, TABLE*, List<Item>&, List<Item>&, bool, bool)

the bug test suite

---
 mysql-test/r/view.result | 13 +++++++++++++
 mysql-test/t/view.test   | 17 +++++++++++++++++
 2 files changed, 30 insertions(+)

diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result
index 0cd2655..5d8f71e 100644
--- a/mysql-test/r/view.result
+++ b/mysql-test/r/view.result
@@ -6333,5 +6333,18 @@ v1	CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VI
 drop view v1;
 drop table t1;
 #
+# MDEV-10704: Assertion `field->field->table == table_arg'
+# failed in fill_record(THD*, TABLE*, List<Item>&, List<Item>&,
+# bool, bool)
+#
+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;
+REPLACE INTO v (f1,f2) VALUES (1,1);
+ERROR HY000: Can not modify more than one base table through a join view 'test.v'
+drop view v;
+drop table t1,t2,t3;
+#
 # End of 10.2 tests
 #
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test
index 3475d32..e5dd22c 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 #


More information about the commits mailing list