~drizzle-trunk/drizzle/development

modified join_nested EXPLAIN output due to innodb stats changes

added added

removed removed

1054

(t8.b=t9.b OR t8.c IS NULL) AND

1055

(t9.a=1);

1056

id select_type table type possible_keys key key_len ref rows filtered Extra

1057

1 SIMPLE t0 ref idx_a idx_a 5 const 1 100.00 Using where

1058

1 SIMPLE t1 ref idx_b idx_b 5 test.t0.b 1 100.00 Using where

1057

1 SIMPLE t0 ref idx_a idx_a 5 const 2 100.00 Using where

1058

1 SIMPLE t1 ALL idx_b NULL NULL NULL 3 100.00 Using where; Using join buffer

1059

1 SIMPLE t2 ALL NULL NULL NULL NULL 3 100.00 Using where

1060

1 SIMPLE t4 ref idx_b idx_b 5 test.t2.b 1 100.00

1061

1 SIMPLE t3 ALL NULL NULL NULL NULL 2 100.00 Using where