diff options
author | Sergei Golubchik <serg@mariadb.org> | 2015-08-05 09:45:36 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2015-08-05 09:45:36 +0200 |
commit | 50ef00663322aeb36b18048193f0d47c9d388ae3 (patch) | |
tree | 5194ab20feb3d18a61b4394484752ed3048270cd /mysql-test/r/subselect_mat.result | |
parent | 928edb5a9139502abf6e1c1b1552234b39d38a78 (diff) | |
parent | d6d54584ee813c6592cecb01eab3d896ed1475a8 (diff) | |
download | mariadb-git-50ef00663322aeb36b18048193f0d47c9d388ae3.tar.gz |
Merge branch '10.0' into bb-10.0-serg
Diffstat (limited to 'mysql-test/r/subselect_mat.result')
-rw-r--r-- | mysql-test/r/subselect_mat.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_mat.result b/mysql-test/r/subselect_mat.result index 9a72e4d12ba..5f3495aae6f 100644 --- a/mysql-test/r/subselect_mat.result +++ b/mysql-test/r/subselect_mat.result @@ -2215,6 +2215,24 @@ 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; set @subselect_mat_test_optimizer_switch_value=null; set @@optimizer_switch='materialization=on,in_to_exists=off,semijoin=off'; set optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on'; |