diff options
Diffstat (limited to 'mysql-test/main/selectivity_no_engine.result')
-rw-r--r-- | mysql-test/main/selectivity_no_engine.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/selectivity_no_engine.result b/mysql-test/main/selectivity_no_engine.result index 3811b12a1be..d8c2b83df2e 100644 --- a/mysql-test/main/selectivity_no_engine.result +++ b/mysql-test/main/selectivity_no_engine.result @@ -237,7 +237,7 @@ explain select * from t1,t2 where t1.id = t2.t1_id and t2.f2='qux' and t2.f1='baz'; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 ref f1 f1 325 const,const 2 Using index condition; Using where -1 SIMPLE t1 eq_ref PRIMARY PRIMARY 122 test.t2.t1_id 1 +1 SIMPLE t1 ALL PRIMARY NULL NULL NULL 2 Using where; Using join buffer (flat, BNL join) select * from t1,t2 where t1.id = t2.t1_id and t2.f2='qux' and t2.f1='baz'; id dt t1_id f1 f2 foo 2011-04-12 05:18:08 foo baz qux |