diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2011-06-22 15:22:27 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2011-06-22 15:22:27 +0400 |
| commit | ed54ec7eb5ee5747293155f50752a47c2c3f1ec7 (patch) | |
| tree | ce2569ce8f31a934df53f3ca0872ae86fc3ca4fa /mysql-test/t/subselect_sj.test | |
| parent | eea95a15d3648fcf01a146813c6de398d08f5246 (diff) | |
| download | mariadb-git-ed54ec7eb5ee5747293155f50752a47c2c3f1ec7.tar.gz | |
Make semi-joins work with outer joins:
- evaluate_null_complemented_join_record() should perform FirstMatch checks.
Diffstat (limited to 'mysql-test/t/subselect_sj.test')
| -rw-r--r-- | mysql-test/t/subselect_sj.test | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_sj.test b/mysql-test/t/subselect_sj.test index 4436373e2a9..515cc4c13d9 100644 --- a/mysql-test/t/subselect_sj.test +++ b/mysql-test/t/subselect_sj.test @@ -1291,6 +1291,12 @@ explain select * from t0 where a in (select t1.a from t1 left join t2 on t1.a=t2.a); select * from t0 where a in (select t1.a from t1 left join t2 on t1.a=t2.a); + +set optimizer_switch='firstmatch=on'; +explain +select * from t0 where a in (select t1.a from t1 left join t2 on t1.a=t2.a); +select * from t0 where a in (select t1.a from t1 left join t2 on t1.a=t2.a); + set @@join_cache_level=@tmp_jcl_20110622; set @@optimizer_switch=@tmp_20110622; |