summaryrefslogtreecommitdiff
path: root/mysql-test/t/explain_non_select.test
diff options
context:
space:
mode:
authorVicențiu Ciorbaru <vicentiu@mariadb.org>2015-05-02 21:46:32 +0300
committerVicențiu Ciorbaru <vicentiu@mariadb.org>2015-05-02 21:46:32 +0300
commitacab0faa146993334e20d86bf685f4e32c588eb3 (patch)
tree662a38dacb0e9444062b989878c0890e822ceb59 /mysql-test/t/explain_non_select.test
parent37093eb51e5db2097f2d4d1bd82f6f019336c5e3 (diff)
downloadmariadb-git-acab0faa146993334e20d86bf685f4e32c588eb3.tar.gz
MDEV-7038 Assertion `status_var.memory_used == 0' failed in THD::~THD() on disconnect after executing EXPLAIN for multi-table UPDATE
Added test case that caught this bug. It is no longer reproducible in the current tree.
Diffstat (limited to 'mysql-test/t/explain_non_select.test')
-rw-r--r--mysql-test/t/explain_non_select.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/explain_non_select.test b/mysql-test/t/explain_non_select.test
index f05373c312e..e36fd518b61 100644
--- a/mysql-test/t/explain_non_select.test
+++ b/mysql-test/t/explain_non_select.test
@@ -197,4 +197,14 @@ select 'OK';
drop function f1;
drop table t1;
+--echo #
+--echo # MDEV-7038: Assertion `status_var.memory_used == 0' failed in THD::~THD()
+--echo # on disconnect after executing EXPLAIN for multi-table UPDATE
+--echo #
+CREATE TABLE t1 (a INT);
+CREATE VIEW v1 AS SELECT * FROM t1;
+INSERT INTO t1 VALUES (1),(2);
+EXPLAIN UPDATE v1, mysql.user SET v1.a = v1.a + 1;
+DROP TABLE t1;
+DROP VIEW v1;