diff options
| author | unknown <sanja@askmonty.org> | 2011-11-29 23:09:06 +0200 |
|---|---|---|
| committer | unknown <sanja@askmonty.org> | 2011-11-29 23:09:06 +0200 |
| commit | 264aaf111d0493f0472e704ad7dda426f81376ea (patch) | |
| tree | 173334feac6841447deef99a00fc815285c3157a /mysql-test/r/subselect_no_semijoin.result | |
| parent | cdde6187d1d2e7f407043f73376c266f540217d9 (diff) | |
| download | mariadb-git-264aaf111d0493f0472e704ad7dda426f81376ea.tar.gz | |
Added test suite for the LP BUG#885162 (fixed by the patch for LP BUG#859375 and LP BUG#887458).
Diffstat (limited to 'mysql-test/r/subselect_no_semijoin.result')
| -rw-r--r-- | mysql-test/r/subselect_no_semijoin.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_no_semijoin.result b/mysql-test/r/subselect_no_semijoin.result index 9f50a975b84..6438f06e179 100644 --- a/mysql-test/r/subselect_no_semijoin.result +++ b/mysql-test/r/subselect_no_semijoin.result @@ -5743,6 +5743,21 @@ b a b set @@join_cache_level= @save_join_cache_level; drop table t1,t2; # +# LP bug #885162 Got error 124 from storage engine with UNION inside +# subquery and join_cache_level=3..8 +# (IN/ALL/ANY optimizations should not be applied to fake_select) +# +CREATE TABLE t1 ( +f1 varchar(1) DEFAULT NULL +); +INSERT INTO t1 VALUES ('c'); +set @save_join_cache_level=@@join_cache_level; +SET SESSION join_cache_level=8; +SELECT * FROM t1 WHERE t1.f1 IN ( SELECT 'k' UNION SELECT 'e' ); +f1 +set @@join_cache_level= @save_join_cache_level; +drop table t1; +# # LP BUG#747278 incorrect values of the NULL (no rows) single # row subquery requested via element_index() interface # |