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).
| Thread |
|---|
| • bzr push into mysql-trunk-cluster branch (ole.john.aske:3579 to 3580) | Ole John Aske | 28 Nov |
