diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2013-09-12 13:53:13 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2013-09-12 13:53:13 +0400 |
| commit | 7e4845beea1a86dc53dc67908a2779ea2f0190a2 (patch) | |
| tree | 4fbee6ef7d564e4361de43378b519a86c951da13 /mysql-test/r/subselect_sj_mat.result | |
| parent | c2b38529a9ca2ea09dfa73186d9350a0d6dcd6ac (diff) | |
| download | mariadb-git-7e4845beea1a86dc53dc67908a2779ea2f0190a2.tar.gz | |
MDEV-5011: ERROR Plugin 'MEMORY' has ref_count=1 after shutdown for SJM queries
- Provide a special execution path for cleanup of degenerate
non-merged semi-join children of degenerate selects.
Diffstat (limited to 'mysql-test/r/subselect_sj_mat.result')
| -rw-r--r-- | mysql-test/r/subselect_sj_mat.result | 8 |
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 fb7fdb0e8f0..61ebe3cf5c3 100644 --- a/mysql-test/r/subselect_sj_mat.result +++ b/mysql-test/r/subselect_sj_mat.result @@ -2055,4 +2055,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 |