190
190
explain SELECT STRAIGHT_JOIN d.pla_id, m2.mat_id FROM t1 m2 INNER JOIN (SELECT mp.pla_id, MIN(m1.matintnum) AS matintnum FROM t2 mp INNER JOIN t1 m1 ON mp.mat_id=m1.mat_id GROUP BY mp.pla_id) d ON d.matintnum=m2.matintnum;
191
191
id select_type table type possible_keys key key_len ref rows Extra
192
192
1 PRIMARY m2 ALL NULL NULL NULL NULL 9
194
194
2 DERIVED mp ALL NULL NULL NULL NULL 9 Using temporary; Using filesort
195
195
2 DERIVED m1 eq_ref PRIMARY PRIMARY 3 test.mp.mat_id 1
196
196
explain SELECT STRAIGHT_JOIN d.pla_id, m2.test FROM t1 m2 INNER JOIN (SELECT mp.pla_id, MIN(m1.matintnum) AS matintnum FROM t2 mp INNER JOIN t1 m1 ON mp.mat_id=m1.mat_id GROUP BY mp.pla_id) d ON d.matintnum=m2.matintnum;
197
197
id select_type table type possible_keys key key_len ref rows Extra
198
198
1 PRIMARY m2 ALL NULL NULL NULL NULL 9
200
200
2 DERIVED mp ALL NULL NULL NULL NULL 9 Using temporary; Using filesort
201
201
2 DERIVED m1 eq_ref PRIMARY PRIMARY 3 test.mp.mat_id 1
203
203
SELECT a.x FROM (SELECT 1 AS x) AS a HAVING a.x = 1;
206
207
create table t1 select 1 as a;
208
209
Table Op Msg_type Msg_text