From 85571ea76cb6f210458b02c6a85f950cb5885c39 Mon Sep 17 00:00:00 2001 From: Sergey Petrunya Date: Thu, 14 Jul 2011 01:53:05 +0400 Subject: Disable LooseScan and FirstMatch when outer joins are present. --- mysql-test/r/subselect_sj2.result | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'mysql-test/r/subselect_sj2.result') diff --git a/mysql-test/r/subselect_sj2.result b/mysql-test/r/subselect_sj2.result index f942f48e207..e71486ab4a8 100644 --- a/mysql-test/r/subselect_sj2.result +++ b/mysql-test/r/subselect_sj2.result @@ -267,10 +267,10 @@ 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 -1 PRIMARY t1 index NULL a 5 NULL 10 Using index +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; FirstMatch(t0) +1 PRIMARY t3 ref a a 5 test.t1.a 1 Using where; Using index; End temporary drop table t0, t1,t2,t3; CREATE TABLE t1 ( ID int(11) NOT NULL auto_increment, -- cgit v1.2.1