1
--- r/join_optimizer.result 2011-11-23 21:52:20.000000000 +0100
2
+++ r/join_optimizer.reject 2012-02-10 16:07:08.000000000 +0100
4
WHERE g.domain = 'queue' AND g.type = a.type;
5
id select_type table type possible_keys key key_len ref rows Extra
6
1 SIMPLE a ALL NULL NULL NULL NULL 2 Using where
7
-1 SIMPLE g ref groups_dt groups_dt 70 const,test.a.type 13 Using index condition
8
+1 SIMPLE g ref groups_dt groups_dt 70 const,test.a.type 1 Using where
9
drop table t0,t1,t2,t3;