4091 Ole John Aske 2012-11-13
Addendum to fix for bug#14709490 testcase: Mask 'rows' from explain result as it is platform dependent.
modified:
mysql-test/suite/ndb/r/ndb_bushy_joins.result
mysql-test/suite/ndb/t/ndb_bushy_joins.test
4090 magnus.blaudd@stripped 2012-11-13 [merge]
Merge
modified:
storage/ndb/compile-cluster
=== modified file 'mysql-test/suite/ndb/r/ndb_bushy_joins.result'
=== modified file 'mysql-test/suite/ndb/r/ndb_bushy_joins.result'
--- a/mysql-test/suite/ndb/r/ndb_bushy_joins.result 2012-11-13 10:27:06 +0000
+++ b/mysql-test/suite/ndb/r/ndb_bushy_joins.result 2012-11-13 15:07:11 +0000
@@ -184,23 +184,23 @@
where parent.a < 1000
;
id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE parent range PRIMARY PRIMARY 4 NULL 1104 Parent of 17 pushed join@1; Using where with pushed condition
-1 SIMPLE c1 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c2 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c3 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c4 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c5 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c6 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c7 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c8 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c9 ref PRIMARY PRIMARY 4 test.c1.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c10 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c11 ref PRIMARY PRIMARY 4 test.c10.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c12 ref PRIMARY PRIMARY 4 test.c10.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c13 ref PRIMARY PRIMARY 4 test.c10.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c14 ref PRIMARY PRIMARY 4 test.c10.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c15 ref PRIMARY PRIMARY 4 test.c10.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c16 ref PRIMARY PRIMARY 4 test.c10.a 54 Child of 'parent' in pushed join@1; Using where
+1 SIMPLE parent range PRIMARY PRIMARY 4 NULL ### Parent of 17 pushed join@1; Using where with pushed condition
+1 SIMPLE c1 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c2 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c3 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c4 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c5 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c6 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c7 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c8 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c9 ref PRIMARY PRIMARY 4 test.c1.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c10 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c11 ref PRIMARY PRIMARY 4 test.c10.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c12 ref PRIMARY PRIMARY 4 test.c10.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c13 ref PRIMARY PRIMARY 4 test.c10.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c14 ref PRIMARY PRIMARY 4 test.c10.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c15 ref PRIMARY PRIMARY 4 test.c10.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c16 ref PRIMARY PRIMARY 4 test.c10.a ### Child of 'parent' in pushed join@1; Using where
select straight_join count(*) from parent
join ref_child as c1 on c1.a = parent.b
join ref_child as c2 on c2.a = parent.b
@@ -261,39 +261,39 @@
where parent.a < 1000
;
id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE parent range PRIMARY PRIMARY 4 NULL 1104 Parent of 32 pushed join@1; Using where with pushed condition
-1 SIMPLE c1 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c1eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c1.b 1 Child of 'c1' in pushed join@1
-1 SIMPLE c2 ref PRIMARY PRIMARY 4 test.c1.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c2eq eq_ref PRIMARY PRIMARY 8 test.c2.a,test.c2.b 1 Child of 'c2' in pushed join@1; Using where
-1 SIMPLE c3 ref PRIMARY PRIMARY 4 test.c2.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c3eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c3.b 1 Child of 'c3' in pushed join@1
-1 SIMPLE c4 ref PRIMARY PRIMARY 4 test.c3.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c4eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c4.b 1 Child of 'c4' in pushed join@1
-1 SIMPLE c5 ref PRIMARY PRIMARY 4 test.c4.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c5eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c5.b 1 Child of 'c5' in pushed join@1
-1 SIMPLE c6 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c6eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c6.b 1 Child of 'c6' in pushed join@1
-1 SIMPLE c7 ref PRIMARY PRIMARY 4 test.c5eq.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c7eq eq_ref PRIMARY PRIMARY 8 test.c6.a,test.c7.b 1 Child of 'c7' in pushed join@1; Using where
-1 SIMPLE c8 ref PRIMARY PRIMARY 4 test.c6eq.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c8eq eq_ref PRIMARY PRIMARY 8 test.c7.a,test.c8.b 1 Child of 'c8' in pushed join@1; Using where
-1 SIMPLE c9 ref PRIMARY PRIMARY 4 test.c6eq.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c9eq eq_ref PRIMARY PRIMARY 8 test.c2eq.a,test.c9.b 1 Child of 'c9' in pushed join@1; Using where
-1 SIMPLE c10 ref PRIMARY PRIMARY 4 test.c7.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c10eq eq_ref PRIMARY PRIMARY 8 test.c7eq.a,test.c10.b 1 Child of 'c10' in pushed join@1; Using where
-1 SIMPLE c11 ref PRIMARY PRIMARY 4 test.c7.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c11eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c11.b 1 Child of 'c11' in pushed join@1
-1 SIMPLE c12 ref PRIMARY PRIMARY 4 test.c8eq.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c12eq eq_ref PRIMARY PRIMARY 8 test.c7.a,test.c12.b 1 Child of 'c12' in pushed join@1; Using where
-1 SIMPLE c13 ref PRIMARY PRIMARY 4 test.c6eq.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c13eq eq_ref PRIMARY PRIMARY 8 test.c6.a,test.c13.b 1 Child of 'c13' in pushed join@1; Using where
-1 SIMPLE c14 ref PRIMARY PRIMARY 4 test.c5.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c14eq eq_ref PRIMARY PRIMARY 8 test.c5eq.a,test.c14.b 1 Child of 'c14' in pushed join@1; Using where
-1 SIMPLE c15 ref PRIMARY PRIMARY 4 test.c1eq.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c15eq eq_ref PRIMARY PRIMARY 8 test.c15.a,test.c15.b 1 Child of 'c15' in pushed join@1; Using where
-1 SIMPLE c16 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c16eq eq_ref PRIMARY PRIMARY 8 test.c5.a,test.c16.b 1 Using where
+1 SIMPLE parent range PRIMARY PRIMARY 4 NULL ### Parent of 32 pushed join@1; Using where with pushed condition
+1 SIMPLE c1 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c1eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c1.b ### Child of 'c1' in pushed join@1
+1 SIMPLE c2 ref PRIMARY PRIMARY 4 test.c1.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c2eq eq_ref PRIMARY PRIMARY 8 test.c2.a,test.c2.b ### Child of 'c2' in pushed join@1; Using where
+1 SIMPLE c3 ref PRIMARY PRIMARY 4 test.c2.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c3eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c3.b ### Child of 'c3' in pushed join@1
+1 SIMPLE c4 ref PRIMARY PRIMARY 4 test.c3.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c4eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c4.b ### Child of 'c4' in pushed join@1
+1 SIMPLE c5 ref PRIMARY PRIMARY 4 test.c4.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c5eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c5.b ### Child of 'c5' in pushed join@1
+1 SIMPLE c6 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c6eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c6.b ### Child of 'c6' in pushed join@1
+1 SIMPLE c7 ref PRIMARY PRIMARY 4 test.c5eq.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c7eq eq_ref PRIMARY PRIMARY 8 test.c6.a,test.c7.b ### Child of 'c7' in pushed join@1; Using where
+1 SIMPLE c8 ref PRIMARY PRIMARY 4 test.c6eq.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c8eq eq_ref PRIMARY PRIMARY 8 test.c7.a,test.c8.b ### Child of 'c8' in pushed join@1; Using where
+1 SIMPLE c9 ref PRIMARY PRIMARY 4 test.c6eq.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c9eq eq_ref PRIMARY PRIMARY 8 test.c2eq.a,test.c9.b ### Child of 'c9' in pushed join@1; Using where
+1 SIMPLE c10 ref PRIMARY PRIMARY 4 test.c7.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c10eq eq_ref PRIMARY PRIMARY 8 test.c7eq.a,test.c10.b ### Child of 'c10' in pushed join@1; Using where
+1 SIMPLE c11 ref PRIMARY PRIMARY 4 test.c7.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c11eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c11.b ### Child of 'c11' in pushed join@1
+1 SIMPLE c12 ref PRIMARY PRIMARY 4 test.c8eq.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c12eq eq_ref PRIMARY PRIMARY 8 test.c7.a,test.c12.b ### Child of 'c12' in pushed join@1; Using where
+1 SIMPLE c13 ref PRIMARY PRIMARY 4 test.c6eq.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c13eq eq_ref PRIMARY PRIMARY 8 test.c6.a,test.c13.b ### Child of 'c13' in pushed join@1; Using where
+1 SIMPLE c14 ref PRIMARY PRIMARY 4 test.c5.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c14eq eq_ref PRIMARY PRIMARY 8 test.c5eq.a,test.c14.b ### Child of 'c14' in pushed join@1; Using where
+1 SIMPLE c15 ref PRIMARY PRIMARY 4 test.c1eq.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c15eq eq_ref PRIMARY PRIMARY 8 test.c15.a,test.c15.b ### Child of 'c15' in pushed join@1; Using where
+1 SIMPLE c16 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c16eq eq_ref PRIMARY PRIMARY 8 test.c5.a,test.c16.b ### Using where
select straight_join count(*) from parent
join ref_child as c1 on c1.a = parent.b
join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
@@ -574,23 +574,23 @@
where parent.a < 1000
;
id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE parent range PRIMARY PRIMARY 4 NULL 1104 Parent of 17 pushed join@1; Using where with pushed condition
-1 SIMPLE c1 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c2 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c3 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c4 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c5 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c6 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c7 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c8 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c9 ref PRIMARY PRIMARY 4 test.c1.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c10 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c11 ref PRIMARY PRIMARY 4 test.c10.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c12 ref PRIMARY PRIMARY 4 test.c10.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c13 ref PRIMARY PRIMARY 4 test.c10.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c14 ref PRIMARY PRIMARY 4 test.c10.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c15 ref PRIMARY PRIMARY 4 test.c10.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c16 ref PRIMARY PRIMARY 4 test.c10.a 54 Child of 'parent' in pushed join@1; Using where
+1 SIMPLE parent range PRIMARY PRIMARY 4 NULL ### Parent of 17 pushed join@1; Using where with pushed condition
+1 SIMPLE c1 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c2 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c3 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c4 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c5 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c6 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c7 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c8 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c9 ref PRIMARY PRIMARY 4 test.c1.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c10 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c11 ref PRIMARY PRIMARY 4 test.c10.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c12 ref PRIMARY PRIMARY 4 test.c10.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c13 ref PRIMARY PRIMARY 4 test.c10.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c14 ref PRIMARY PRIMARY 4 test.c10.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c15 ref PRIMARY PRIMARY 4 test.c10.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c16 ref PRIMARY PRIMARY 4 test.c10.a ### Child of 'parent' in pushed join@1; Using where
select straight_join count(*) from parent
join ref_child as c1 on c1.a = parent.b
join ref_child as c2 on c2.a = parent.b
@@ -694,39 +694,39 @@
where parent.a < 1000
;
id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE parent range PRIMARY PRIMARY 4 NULL 1104 Parent of 32 pushed join@1; Using where with pushed condition
-1 SIMPLE c1 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c1eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c1.b 1 Child of 'c1' in pushed join@1
-1 SIMPLE c2 ref PRIMARY PRIMARY 4 test.c1.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c2eq eq_ref PRIMARY PRIMARY 8 test.c2.a,test.c2.b 1 Child of 'c2' in pushed join@1; Using where
-1 SIMPLE c3 ref PRIMARY PRIMARY 4 test.c2.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c3eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c3.b 1 Child of 'c3' in pushed join@1
-1 SIMPLE c4 ref PRIMARY PRIMARY 4 test.c3.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c4eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c4.b 1 Child of 'c4' in pushed join@1
-1 SIMPLE c5 ref PRIMARY PRIMARY 4 test.c4.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c5eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c5.b 1 Child of 'c5' in pushed join@1
-1 SIMPLE c6 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c6eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c6.b 1 Child of 'c6' in pushed join@1
-1 SIMPLE c7 ref PRIMARY PRIMARY 4 test.c5eq.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c7eq eq_ref PRIMARY PRIMARY 8 test.c6.a,test.c7.b 1 Child of 'c7' in pushed join@1; Using where
-1 SIMPLE c8 ref PRIMARY PRIMARY 4 test.c6eq.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c8eq eq_ref PRIMARY PRIMARY 8 test.c7.a,test.c8.b 1 Child of 'c8' in pushed join@1; Using where
-1 SIMPLE c9 ref PRIMARY PRIMARY 4 test.c6eq.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c9eq eq_ref PRIMARY PRIMARY 8 test.c2eq.a,test.c9.b 1 Child of 'c9' in pushed join@1; Using where
-1 SIMPLE c10 ref PRIMARY PRIMARY 4 test.c7.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c10eq eq_ref PRIMARY PRIMARY 8 test.c7eq.a,test.c10.b 1 Child of 'c10' in pushed join@1; Using where
-1 SIMPLE c11 ref PRIMARY PRIMARY 4 test.c7.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c11eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c11.b 1 Child of 'c11' in pushed join@1
-1 SIMPLE c12 ref PRIMARY PRIMARY 4 test.c8eq.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c12eq eq_ref PRIMARY PRIMARY 8 test.c7.a,test.c12.b 1 Child of 'c12' in pushed join@1; Using where
-1 SIMPLE c13 ref PRIMARY PRIMARY 4 test.c6eq.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c13eq eq_ref PRIMARY PRIMARY 8 test.c6.a,test.c13.b 1 Child of 'c13' in pushed join@1; Using where
-1 SIMPLE c14 ref PRIMARY PRIMARY 4 test.c5.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c14eq eq_ref PRIMARY PRIMARY 8 test.c5eq.a,test.c14.b 1 Child of 'c14' in pushed join@1; Using where
-1 SIMPLE c15 ref PRIMARY PRIMARY 4 test.c1eq.a 54 Child of 'parent' in pushed join@1; Using where
-1 SIMPLE c15eq eq_ref PRIMARY PRIMARY 8 test.c15.a,test.c15.b 1 Child of 'c15' in pushed join@1; Using where
-1 SIMPLE c16 ref PRIMARY PRIMARY 4 test.parent.b 54 Child of 'parent' in pushed join@1
-1 SIMPLE c16eq eq_ref PRIMARY PRIMARY 8 test.c5.a,test.c16.b 1 Using where
+1 SIMPLE parent range PRIMARY PRIMARY 4 NULL ### Parent of 32 pushed join@1; Using where with pushed condition
+1 SIMPLE c1 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c1eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c1.b ### Child of 'c1' in pushed join@1
+1 SIMPLE c2 ref PRIMARY PRIMARY 4 test.c1.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c2eq eq_ref PRIMARY PRIMARY 8 test.c2.a,test.c2.b ### Child of 'c2' in pushed join@1; Using where
+1 SIMPLE c3 ref PRIMARY PRIMARY 4 test.c2.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c3eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c3.b ### Child of 'c3' in pushed join@1
+1 SIMPLE c4 ref PRIMARY PRIMARY 4 test.c3.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c4eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c4.b ### Child of 'c4' in pushed join@1
+1 SIMPLE c5 ref PRIMARY PRIMARY 4 test.c4.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c5eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c5.b ### Child of 'c5' in pushed join@1
+1 SIMPLE c6 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c6eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c6.b ### Child of 'c6' in pushed join@1
+1 SIMPLE c7 ref PRIMARY PRIMARY 4 test.c5eq.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c7eq eq_ref PRIMARY PRIMARY 8 test.c6.a,test.c7.b ### Child of 'c7' in pushed join@1; Using where
+1 SIMPLE c8 ref PRIMARY PRIMARY 4 test.c6eq.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c8eq eq_ref PRIMARY PRIMARY 8 test.c7.a,test.c8.b ### Child of 'c8' in pushed join@1; Using where
+1 SIMPLE c9 ref PRIMARY PRIMARY 4 test.c6eq.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c9eq eq_ref PRIMARY PRIMARY 8 test.c2eq.a,test.c9.b ### Child of 'c9' in pushed join@1; Using where
+1 SIMPLE c10 ref PRIMARY PRIMARY 4 test.c7.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c10eq eq_ref PRIMARY PRIMARY 8 test.c7eq.a,test.c10.b ### Child of 'c10' in pushed join@1; Using where
+1 SIMPLE c11 ref PRIMARY PRIMARY 4 test.c7.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c11eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c11.b ### Child of 'c11' in pushed join@1
+1 SIMPLE c12 ref PRIMARY PRIMARY 4 test.c8eq.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c12eq eq_ref PRIMARY PRIMARY 8 test.c7.a,test.c12.b ### Child of 'c12' in pushed join@1; Using where
+1 SIMPLE c13 ref PRIMARY PRIMARY 4 test.c6eq.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c13eq eq_ref PRIMARY PRIMARY 8 test.c6.a,test.c13.b ### Child of 'c13' in pushed join@1; Using where
+1 SIMPLE c14 ref PRIMARY PRIMARY 4 test.c5.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c14eq eq_ref PRIMARY PRIMARY 8 test.c5eq.a,test.c14.b ### Child of 'c14' in pushed join@1; Using where
+1 SIMPLE c15 ref PRIMARY PRIMARY 4 test.c1eq.a ### Child of 'parent' in pushed join@1; Using where
+1 SIMPLE c15eq eq_ref PRIMARY PRIMARY 8 test.c15.a,test.c15.b ### Child of 'c15' in pushed join@1; Using where
+1 SIMPLE c16 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1
+1 SIMPLE c16eq eq_ref PRIMARY PRIMARY 8 test.c5.a,test.c16.b ### Using where
select straight_join count(*) from parent
join ref_child as c1 on c1.a = parent.b
join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
=== modified file 'mysql-test/suite/ndb/t/ndb_bushy_joins.test'
--- a/mysql-test/suite/ndb/t/ndb_bushy_joins.test 2012-11-13 12:07:51 +0000
+++ b/mysql-test/suite/ndb/t/ndb_bushy_joins.test 2012-11-13 15:07:11 +0000
@@ -9,6 +9,11 @@
# job buffer overflow as too many requests was
# sent in parallel from the SPJ block.
# (bug#14709490)
+#
+# '--replace_column 9 ###' is used for explains throughout
+# the test as experience has shown that 'rows' estimates
+# may vary depending on OS, compiler and .. phase of moon.
+#
########################################################
--source include/not_embedded.inc
@@ -175,12 +180,14 @@
-- echo ===============================
-- echo Run single instance of 'query3'
-- echo ===============================
+--replace_column 9 ###
eval explain $query3;
eval $query3;
-- echo ===============================
-- echo Run single instance of 'query4'
-- echo ===============================
+--replace_column 9 ###
eval explain $query4;
eval $query4;
@@ -229,6 +236,7 @@
-- echo Run multiple 'query3' in parallel
-- echo =================================
let $query = $query3;
+--replace_column 9 ###
eval explain $query;
connection j1;
send_eval $query;
@@ -249,6 +257,7 @@
-- echo Run multiple 'query4' in parallel
-- echo =================================
let $query = $query4;
+--replace_column 9 ###
eval explain $query;
connection j1;
send_eval $query;
No bundle (reason: useless for push emails).
| Thread |
|---|
| • bzr push into mysql-5.5-cluster-7.2 branch (ole.john.aske:4090 to 4091)Bug#14709490 | Ole John Aske | 14 Nov |
