summaryrefslogtreecommitdiff
path: root/mysql-test/r/subselect_sj_mat.result
diff options
context:
space:
mode:
authorSergey Petrunya <psergey@askmonty.org>2013-09-12 13:54:46 +0400
committerSergey Petrunya <psergey@askmonty.org>2013-09-12 13:54:46 +0400
commit33f807fd91826013499c996f9515838cf2c6d0c5 (patch)
tree50a6bd91fc3772d6f7e505fa9e7adcaca456c26b /mysql-test/r/subselect_sj_mat.result
parentadf637dff6484e602567a5294a43cb4b3aea606f (diff)
parent7e4845beea1a86dc53dc67908a2779ea2f0190a2 (diff)
downloadmariadb-git-33f807fd91826013499c996f9515838cf2c6d0c5.tar.gz
Merge 5.3 -> 5.5
Diffstat (limited to 'mysql-test/r/subselect_sj_mat.result')
-rw-r--r--mysql-test/r/subselect_sj_mat.result8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_sj_mat.result b/mysql-test/r/subselect_sj_mat.result
index 6f1694944d8..bcdd82b790c 100644
--- a/mysql-test/r/subselect_sj_mat.result
+++ b/mysql-test/r/subselect_sj_mat.result
@@ -2069,4 +2069,12 @@ SELECT * FROM t1 WHERE 8 IN ( SELECT MIN(pk) FROM t1 ) AND ( pk = a OR pk = b );
pk a b
drop table t1;
SET optimizer_switch=@save_optimizer_switch;
+#
+# MDEV-5011: ERROR Plugin 'MEMORY' has ref_count=1 after shutdown for SJM queries
+#
+CREATE TABLE t1 (pk INT, a INT, b INT, PRIMARY KEY(pk)) ENGINE=MyISAM;
+INSERT INTO t1 VALUES (1,3,5),(2,4,6);
+SELECT * FROM t1 WHERE 8 IN (SELECT MIN(pk) FROM t1) AND (pk = a OR pk = b);
+pk a b
+DROP TABLE t1;
# End of 5.3 tests