diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2011-07-05 21:22:13 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2011-07-05 21:22:13 +0400 |
| commit | 05d54b121ca06e54050f4ca818aca56ca5e80890 (patch) | |
| tree | 39ee3d47df7d0d88c0709344e980129e0087c45e /mysql-test/r/subselect_sj2_mat.result | |
| parent | 85fb8bb4666f2db662fa580b6bd959508010fa42 (diff) | |
| download | mariadb-git-05d54b121ca06e54050f4ca818aca56ca5e80890.tar.gz | |
BUG#803365: Crash in pull_out_semijoin_tables with outer join + semijoin + derived tables in maria-5.3 with WL#106
- Don't perform table pullout out of semi-join nests that have nested outer joins.
Diffstat (limited to 'mysql-test/r/subselect_sj2_mat.result')
| -rw-r--r-- | mysql-test/r/subselect_sj2_mat.result | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/mysql-test/r/subselect_sj2_mat.result b/mysql-test/r/subselect_sj2_mat.result index 0919e8701e2..52dd3df1f5e 100644 --- a/mysql-test/r/subselect_sj2_mat.result +++ b/mysql-test/r/subselect_sj2_mat.result @@ -273,10 +273,11 @@ explain select * from t0 where a in (select t2.a+t3.a from t1 left join (t2 join t3) on t2.a=t1.a and t3.a=t1.a); id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY t0 ALL NULL NULL NULL NULL 10 Start temporary -1 PRIMARY t1 index NULL a 5 NULL 10 Using index; Using join buffer (flat, BNL join) -1 PRIMARY t2 ref a a 5 test.t1.a 1 Using where; Using index -1 PRIMARY t3 ref a a 5 test.t1.a 1 Using where; Using index; End temporary +1 PRIMARY t0 ALL NULL NULL NULL NULL 10 +1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 9 func 1 +2 SUBQUERY t1 index NULL a 5 NULL 10 Using index +2 SUBQUERY t2 ref a a 5 test.t1.a 1 Using where; Using index +2 SUBQUERY t3 ref a a 5 test.t1.a 1 Using index drop table t0, t1,t2,t3; CREATE TABLE t1 ( ID int(11) NOT NULL auto_increment, |