From: Ole John Aske Date: November 28 2012 8:30am Subject: bzr push into mysql-trunk-cluster branch (ole.john.aske:3579 to 3580) List-Archive: http://lists.mysql.com/commits/145396 Message-Id: <20121128083032.4621.53090.3580@khepri40.no.oracle.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 3580 Ole John Aske 2012-11-28 [merge] Merge mysql-5.6-cluster-7.3 -> mysql-trunk->cluster modified: mysql-test/suite/ndb/r/ndb_bushy_joins.result 3579 magnus.blaudd@stripped 2012-11-27 [merge] Merge 7.3 -> trunk-cluster modified: sql/sql_show.cc storage/ndb/CMakeLists.txt storage/ndb/memcache/include/DataTypeHandler.h storage/ndb/memcache/src/DataTypeHandler.cc storage/ndb/memcache/src/ExpireTime.cc storage/ndb/memcache/src/Record.cc storage/ndb/src/common/util/NdbSqlUtil.cpp storage/ndb/src/mgmsrv/ConfigManager.cpp storage/ndb/test/ndbapi/testMgmd.cpp === 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 15:07:11 +0000 +++ b/mysql-test/suite/ndb/r/ndb_bushy_joins.result 2012-11-28 08:18:29 +0000 @@ -53,23 +53,23 @@ join eq_child as c16 on c16.a = parent.b and c16.b = parent.b ; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE parent ALL NULL NULL NULL NULL 8192 Parent of 17 pushed join@1 +1 SIMPLE parent ALL NULL NULL NULL NULL 8192 Parent of 17 pushed join@1; Using where with pushed condition 1 SIMPLE c1 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'parent' in pushed join@1 -1 SIMPLE c2 eq_ref PRIMARY PRIMARY 8 test.c1.a,test.c1.b 1 Child of 'c1' in pushed join@1; Using where -1 SIMPLE c3 eq_ref PRIMARY PRIMARY 8 test.c2.a,test.c2.a 1 Child of 'c2' in pushed join@1; Using where -1 SIMPLE c4 eq_ref PRIMARY PRIMARY 8 test.c3.a,test.c1.b 1 Child of 'c3' in pushed join@1; Using where -1 SIMPLE c5 eq_ref PRIMARY PRIMARY 8 test.c4.a,test.c1.a 1 Child of 'c4' in pushed join@1; Using where -1 SIMPLE c6 eq_ref PRIMARY PRIMARY 8 test.c5.b,test.c5.a 1 Child of 'c5' in pushed join@1; Using where -1 SIMPLE c7 eq_ref PRIMARY PRIMARY 8 test.c4.a,test.c6.a 1 Child of 'c6' in pushed join@1; Using where +1 SIMPLE c2 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c1' in pushed join@1 +1 SIMPLE c3 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c2' in pushed join@1 +1 SIMPLE c4 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c3' in pushed join@1 +1 SIMPLE c5 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c4' in pushed join@1 +1 SIMPLE c6 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c5' in pushed join@1 +1 SIMPLE c7 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c6' in pushed join@1 1 SIMPLE c8 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c7' in pushed join@1 -1 SIMPLE c9 eq_ref PRIMARY PRIMARY 8 test.c1.b,test.parent.b 1 Child of 'c8' in pushed join@1; Using where -1 SIMPLE c10 eq_ref PRIMARY PRIMARY 8 test.c5.b,test.c7.b 1 Child of 'c9' in pushed join@1; Using where -1 SIMPLE c11 eq_ref PRIMARY PRIMARY 8 test.c4.a,test.c7.b 1 Child of 'c10' in pushed join@1; Using where -1 SIMPLE c12 eq_ref PRIMARY PRIMARY 8 test.c5.b,test.c1.b 1 Child of 'c11' in pushed join@1; Using where -1 SIMPLE c13 eq_ref PRIMARY PRIMARY 8 test.c7.a,test.c1.b 1 Child of 'c12' in pushed join@1; Using where -1 SIMPLE c14 eq_ref PRIMARY PRIMARY 8 test.c5.a,test.c7.b 1 Child of 'c13' in pushed join@1; Using where -1 SIMPLE c15 eq_ref PRIMARY PRIMARY 8 test.c5.b,test.c1.b 1 Child of 'c14' in pushed join@1; Using where -1 SIMPLE c16 eq_ref PRIMARY PRIMARY 8 test.c7.a,test.c15.b 1 Child of 'c15' in pushed join@1; Using where +1 SIMPLE c9 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c8' in pushed join@1 +1 SIMPLE c10 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c9' in pushed join@1 +1 SIMPLE c11 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c10' in pushed join@1 +1 SIMPLE c12 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c11' in pushed join@1 +1 SIMPLE c13 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c12' in pushed join@1 +1 SIMPLE c14 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c13' in pushed join@1 +1 SIMPLE c15 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c14' in pushed join@1 +1 SIMPLE c16 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c15' in pushed join@1 select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c2 on c2.a = parent.b and c2.b = parent.b @@ -116,27 +116,27 @@ join eq_child as c20 on c20.a = c4.c and c20.b = c4.c ; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE parent ALL NULL NULL NULL NULL 8192 Parent of 21 pushed join@1 -1 SIMPLE c1 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'parent' in pushed join@1 +1 SIMPLE parent ALL NULL NULL NULL NULL 8192 Parent of 21 pushed join@1; Using where with pushed condition +1 SIMPLE c1 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'parent' in pushed join@1; Using where with pushed condition 1 SIMPLE c5 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 Child of 'c1' in pushed join@1 1 SIMPLE c6 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 Child of 'c5' in pushed join@1 -1 SIMPLE c7 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c5.b 1 Child of 'c6' in pushed join@1; Using where -1 SIMPLE c8 eq_ref PRIMARY PRIMARY 8 test.c7.b,test.c1.c 1 Child of 'c7' in pushed join@1; Using where -1 SIMPLE c2 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c1' in pushed join@1 +1 SIMPLE c7 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 Child of 'c6' in pushed join@1 +1 SIMPLE c8 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 Child of 'c7' in pushed join@1 +1 SIMPLE c2 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c1' in pushed join@1; Using where with pushed condition 1 SIMPLE c9 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 Child of 'c2' in pushed join@1 -1 SIMPLE c10 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c9.b 1 Child of 'c9' in pushed join@1; Using where -1 SIMPLE c11 eq_ref PRIMARY PRIMARY 8 test.c9.a,test.c9.b 1 Child of 'c10' in pushed join@1; Using where -1 SIMPLE c12 eq_ref PRIMARY PRIMARY 8 test.c10.b,test.c9.a 1 Child of 'c11' in pushed join@1; Using where -1 SIMPLE c3 eq_ref PRIMARY PRIMARY 8 test.c1.b,test.c1.b 1 Child of 'c2' in pushed join@1; Using where +1 SIMPLE c10 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 Child of 'c9' in pushed join@1 +1 SIMPLE c11 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 Child of 'c10' in pushed join@1 +1 SIMPLE c12 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 Child of 'c11' in pushed join@1 +1 SIMPLE c3 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c2' in pushed join@1; Using where with pushed condition 1 SIMPLE c13 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 Child of 'c3' in pushed join@1 -1 SIMPLE c14 eq_ref PRIMARY PRIMARY 8 test.c13.a,test.c13.b 1 Child of 'c13' in pushed join@1; Using where -1 SIMPLE c15 eq_ref PRIMARY PRIMARY 8 test.c13.b,test.c3.c 1 Child of 'c14' in pushed join@1; Using where -1 SIMPLE c16 eq_ref PRIMARY PRIMARY 8 test.c15.a,test.c13.a 1 Child of 'c15' in pushed join@1; Using where -1 SIMPLE c4 eq_ref PRIMARY PRIMARY 8 test.c1.a,test.parent.b 1 Child of 'c3' in pushed join@1; Using where +1 SIMPLE c14 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 Child of 'c13' in pushed join@1 +1 SIMPLE c15 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 Child of 'c14' in pushed join@1 +1 SIMPLE c16 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 Child of 'c15' in pushed join@1 +1 SIMPLE c4 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c3' in pushed join@1; Using where with pushed condition 1 SIMPLE c17 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 Child of 'c4' in pushed join@1 1 SIMPLE c18 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 Child of 'c17' in pushed join@1 -1 SIMPLE c19 eq_ref PRIMARY PRIMARY 8 test.c17.a,test.c17.b 1 Child of 'c18' in pushed join@1; Using where -1 SIMPLE c20 eq_ref PRIMARY PRIMARY 8 test.c19.b,test.c19.a 1 Child of 'c19' in pushed join@1; Using where +1 SIMPLE c19 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 Child of 'c18' in pushed join@1 +1 SIMPLE c20 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 Child of 'c19' in pushed join@1 select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c5 on c5.a = c1.c and c5.b = c1.c @@ -184,7 +184,7 @@ 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 ### Parent of 17 pushed join@1; Using where with pushed condition +1 SIMPLE parent range PRIMARY PRIMARY 4 NULL ### Parent of 17 pushed join@1; Using where with pushed condition; Using MRR 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 @@ -193,14 +193,14 @@ 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 c9 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 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 +1 SIMPLE c11 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c12 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c13 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c14 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c15 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c16 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 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 ### Parent of 32 pushed join@1; Using where with pushed condition +1 SIMPLE parent range PRIMARY PRIMARY 4 NULL ### Parent of 32 pushed join@1; Using where with pushed condition; Using MRR 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 c2 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c2eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c2.b ### Child of 'c2' in pushed join@1 +1 SIMPLE c3 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 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 c4 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 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 c5 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 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 c7 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c7eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c7.b ### Child of 'c7' in pushed join@1 +1 SIMPLE c8 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c8eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c8.b ### Child of 'c8' in pushed join@1 +1 SIMPLE c9 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c9eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c9.b ### Child of 'c9' in pushed join@1 +1 SIMPLE c10 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c10eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c10.b ### Child of 'c10' in pushed join@1 +1 SIMPLE c11 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 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 c12 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c12eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c12.b ### Child of 'c12' in pushed join@1 +1 SIMPLE c13 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c13eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c13.b ### Child of 'c13' in pushed join@1 +1 SIMPLE c14 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c14eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c14.b ### Child of 'c14' in pushed join@1 +1 SIMPLE c15 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c15eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c15.b ### Child of 'c15' in pushed join@1 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 +1 SIMPLE c16eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c16.b ### NULL 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 @@ -353,23 +353,23 @@ join eq_child as c16 on c16.a = parent.b and c16.b = parent.b ; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE parent ALL NULL NULL NULL NULL 8192 Parent of 17 pushed join@1 +1 SIMPLE parent ALL NULL NULL NULL NULL 8192 Parent of 17 pushed join@1; Using where with pushed condition 1 SIMPLE c1 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'parent' in pushed join@1 -1 SIMPLE c2 eq_ref PRIMARY PRIMARY 8 test.c1.a,test.c1.b 1 Child of 'c1' in pushed join@1; Using where -1 SIMPLE c3 eq_ref PRIMARY PRIMARY 8 test.c2.a,test.c2.a 1 Child of 'c2' in pushed join@1; Using where -1 SIMPLE c4 eq_ref PRIMARY PRIMARY 8 test.c3.a,test.c1.b 1 Child of 'c3' in pushed join@1; Using where -1 SIMPLE c5 eq_ref PRIMARY PRIMARY 8 test.c4.a,test.c1.a 1 Child of 'c4' in pushed join@1; Using where -1 SIMPLE c6 eq_ref PRIMARY PRIMARY 8 test.c5.b,test.c5.a 1 Child of 'c5' in pushed join@1; Using where -1 SIMPLE c7 eq_ref PRIMARY PRIMARY 8 test.c4.a,test.c6.a 1 Child of 'c6' in pushed join@1; Using where +1 SIMPLE c2 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c1' in pushed join@1 +1 SIMPLE c3 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c2' in pushed join@1 +1 SIMPLE c4 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c3' in pushed join@1 +1 SIMPLE c5 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c4' in pushed join@1 +1 SIMPLE c6 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c5' in pushed join@1 +1 SIMPLE c7 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c6' in pushed join@1 1 SIMPLE c8 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c7' in pushed join@1 -1 SIMPLE c9 eq_ref PRIMARY PRIMARY 8 test.c1.b,test.parent.b 1 Child of 'c8' in pushed join@1; Using where -1 SIMPLE c10 eq_ref PRIMARY PRIMARY 8 test.c5.b,test.c7.b 1 Child of 'c9' in pushed join@1; Using where -1 SIMPLE c11 eq_ref PRIMARY PRIMARY 8 test.c4.a,test.c7.b 1 Child of 'c10' in pushed join@1; Using where -1 SIMPLE c12 eq_ref PRIMARY PRIMARY 8 test.c5.b,test.c1.b 1 Child of 'c11' in pushed join@1; Using where -1 SIMPLE c13 eq_ref PRIMARY PRIMARY 8 test.c7.a,test.c1.b 1 Child of 'c12' in pushed join@1; Using where -1 SIMPLE c14 eq_ref PRIMARY PRIMARY 8 test.c5.a,test.c7.b 1 Child of 'c13' in pushed join@1; Using where -1 SIMPLE c15 eq_ref PRIMARY PRIMARY 8 test.c5.b,test.c1.b 1 Child of 'c14' in pushed join@1; Using where -1 SIMPLE c16 eq_ref PRIMARY PRIMARY 8 test.c7.a,test.c15.b 1 Child of 'c15' in pushed join@1; Using where +1 SIMPLE c9 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c8' in pushed join@1 +1 SIMPLE c10 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c9' in pushed join@1 +1 SIMPLE c11 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c10' in pushed join@1 +1 SIMPLE c12 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c11' in pushed join@1 +1 SIMPLE c13 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c12' in pushed join@1 +1 SIMPLE c14 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c13' in pushed join@1 +1 SIMPLE c15 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c14' in pushed join@1 +1 SIMPLE c16 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c15' in pushed join@1 select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c2 on c2.a = parent.b and c2.b = parent.b @@ -457,27 +457,27 @@ join eq_child as c20 on c20.a = c4.c and c20.b = c4.c ; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE parent ALL NULL NULL NULL NULL 8192 Parent of 21 pushed join@1 -1 SIMPLE c1 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'parent' in pushed join@1 +1 SIMPLE parent ALL NULL NULL NULL NULL 8192 Parent of 21 pushed join@1; Using where with pushed condition +1 SIMPLE c1 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'parent' in pushed join@1; Using where with pushed condition 1 SIMPLE c5 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 Child of 'c1' in pushed join@1 1 SIMPLE c6 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 Child of 'c5' in pushed join@1 -1 SIMPLE c7 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c5.b 1 Child of 'c6' in pushed join@1; Using where -1 SIMPLE c8 eq_ref PRIMARY PRIMARY 8 test.c7.b,test.c1.c 1 Child of 'c7' in pushed join@1; Using where -1 SIMPLE c2 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c1' in pushed join@1 +1 SIMPLE c7 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 Child of 'c6' in pushed join@1 +1 SIMPLE c8 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 Child of 'c7' in pushed join@1 +1 SIMPLE c2 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c1' in pushed join@1; Using where with pushed condition 1 SIMPLE c9 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 Child of 'c2' in pushed join@1 -1 SIMPLE c10 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c9.b 1 Child of 'c9' in pushed join@1; Using where -1 SIMPLE c11 eq_ref PRIMARY PRIMARY 8 test.c9.a,test.c9.b 1 Child of 'c10' in pushed join@1; Using where -1 SIMPLE c12 eq_ref PRIMARY PRIMARY 8 test.c10.b,test.c9.a 1 Child of 'c11' in pushed join@1; Using where -1 SIMPLE c3 eq_ref PRIMARY PRIMARY 8 test.c1.b,test.c1.b 1 Child of 'c2' in pushed join@1; Using where +1 SIMPLE c10 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 Child of 'c9' in pushed join@1 +1 SIMPLE c11 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 Child of 'c10' in pushed join@1 +1 SIMPLE c12 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 Child of 'c11' in pushed join@1 +1 SIMPLE c3 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c2' in pushed join@1; Using where with pushed condition 1 SIMPLE c13 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 Child of 'c3' in pushed join@1 -1 SIMPLE c14 eq_ref PRIMARY PRIMARY 8 test.c13.a,test.c13.b 1 Child of 'c13' in pushed join@1; Using where -1 SIMPLE c15 eq_ref PRIMARY PRIMARY 8 test.c13.b,test.c3.c 1 Child of 'c14' in pushed join@1; Using where -1 SIMPLE c16 eq_ref PRIMARY PRIMARY 8 test.c15.a,test.c13.a 1 Child of 'c15' in pushed join@1; Using where -1 SIMPLE c4 eq_ref PRIMARY PRIMARY 8 test.c1.a,test.parent.b 1 Child of 'c3' in pushed join@1; Using where +1 SIMPLE c14 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 Child of 'c13' in pushed join@1 +1 SIMPLE c15 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 Child of 'c14' in pushed join@1 +1 SIMPLE c16 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 Child of 'c15' in pushed join@1 +1 SIMPLE c4 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 Child of 'c3' in pushed join@1; Using where with pushed condition 1 SIMPLE c17 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 Child of 'c4' in pushed join@1 1 SIMPLE c18 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 Child of 'c17' in pushed join@1 -1 SIMPLE c19 eq_ref PRIMARY PRIMARY 8 test.c17.a,test.c17.b 1 Child of 'c18' in pushed join@1; Using where -1 SIMPLE c20 eq_ref PRIMARY PRIMARY 8 test.c19.b,test.c19.a 1 Child of 'c19' in pushed join@1; Using where +1 SIMPLE c19 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 Child of 'c18' in pushed join@1 +1 SIMPLE c20 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 Child of 'c19' in pushed join@1 select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c5 on c5.a = c1.c and c5.b = c1.c @@ -574,7 +574,7 @@ 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 ### Parent of 17 pushed join@1; Using where with pushed condition +1 SIMPLE parent range PRIMARY PRIMARY 4 NULL ### Parent of 17 pushed join@1; Using where with pushed condition; Using MRR 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 @@ -583,14 +583,14 @@ 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 c9 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 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 +1 SIMPLE c11 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c12 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c13 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c14 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c15 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c16 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 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 ### Parent of 32 pushed join@1; Using where with pushed condition +1 SIMPLE parent range PRIMARY PRIMARY 4 NULL ### Parent of 32 pushed join@1; Using where with pushed condition; Using MRR 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 c2 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c2eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c2.b ### Child of 'c2' in pushed join@1 +1 SIMPLE c3 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 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 c4 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 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 c5 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 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 c7 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c7eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c7.b ### Child of 'c7' in pushed join@1 +1 SIMPLE c8 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c8eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c8.b ### Child of 'c8' in pushed join@1 +1 SIMPLE c9 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c9eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c9.b ### Child of 'c9' in pushed join@1 +1 SIMPLE c10 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c10eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c10.b ### Child of 'c10' in pushed join@1 +1 SIMPLE c11 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 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 c12 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c12eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c12.b ### Child of 'c12' in pushed join@1 +1 SIMPLE c13 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c13eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c13.b ### Child of 'c13' in pushed join@1 +1 SIMPLE c14 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c14eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c14.b ### Child of 'c14' in pushed join@1 +1 SIMPLE c15 ref PRIMARY PRIMARY 4 test.parent.b ### Child of 'parent' in pushed join@1 +1 SIMPLE c15eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c15.b ### Child of 'c15' in pushed join@1 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 +1 SIMPLE c16eq eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c16.b ### NULL 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 No bundle (reason: useless for push emails).