List:Commits« Previous MessageNext Message »
From:Ole John Aske Date:November 28 2012 8:30am
Subject:bzr push into mysql-trunk-cluster branch (ole.john.aske:3579 to 3580)
View as plain text  
 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 Aske28 Nov