summaryrefslogtreecommitdiff
path: root/mysql-test/r/subselect_sj_mat.result
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2015-08-05 09:45:36 +0200
committerSergei Golubchik <serg@mariadb.org>2015-08-05 09:45:36 +0200
commit50ef00663322aeb36b18048193f0d47c9d388ae3 (patch)
tree5194ab20feb3d18a61b4394484752ed3048270cd /mysql-test/r/subselect_sj_mat.result
parent928edb5a9139502abf6e1c1b1552234b39d38a78 (diff)
parentd6d54584ee813c6592cecb01eab3d896ed1475a8 (diff)
downloadmariadb-git-50ef00663322aeb36b18048193f0d47c9d388ae3.tar.gz
Merge branch '10.0' into bb-10.0-serg
Diffstat (limited to 'mysql-test/r/subselect_sj_mat.result')
-rw-r--r--mysql-test/r/subselect_sj_mat.result18
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_sj_mat.result b/mysql-test/r/subselect_sj_mat.result
index 1484a111ff2..34d5834bff4 100644
--- a/mysql-test/r/subselect_sj_mat.result
+++ b/mysql-test/r/subselect_sj_mat.result
@@ -2255,3 +2255,21 @@ Handler_read_rnd_next 6003
Handler_tmp_write 2000
Handler_write 1000
drop table t0,t1,t2,t3;
+#
+# MDEV-7971: Assertion `name != __null' failed in ACL_internal_schema_registry::lookup
+# on 2nd execution os PS with multi-table update
+#
+CREATE TABLE t1 (f1 INT);
+INSERT INTO t1 VALUES (1),(2);
+CREATE TABLE t2 (f2 INT);
+INSERT INTO t2 VALUES (3),(4);
+CREATE TABLE t3 (f3 INT);
+INSERT INTO t3 VALUES (5),(6);
+PREPARE stmt FROM '
+ UPDATE t1, t2
+ SET f1 = 5
+ WHERE 8 IN ( SELECT MIN(f3) FROM t3 )
+';
+EXECUTE stmt;
+EXECUTE stmt;
+DROP TABLE t1,t2,t3;