1893
1893
WHERE a IN (SELECT MAX(c) FROM t2) AND b=7 AND (a IS NULL OR a=b);
1894
1894
id select_type table type possible_keys key key_len ref rows filtered Extra
1896
1896
1 PRIMARY t1 ALL NULL NULL NULL NULL 3 100.00 Using where; Using join buffer (flat, BNL join)
1897
1897
2 MATERIALIZED t2 ALL NULL NULL NULL NULL 3 100.00