[Commits] 995f622: MDEV-7858: main.subselect_sj2_jcl6 fails in buildbot

Sergei Petrunia psergey at askmonty.org
Mon Mar 30 00:49:16 EEST 2015


revision-id: 995f622ceaf96d8e37d260cba0833975e61c756f
parent(s): 86f46a3da4a6d82cb510dc4c270d46cfd6a8965b
committer: Sergei Petrunia
branch nick: 5.5
timestamp: 2015-03-30 00:49:16 +0300
message:

MDEV-7858: main.subselect_sj2_jcl6 fails in buildbot

Update test results after the patch for MDEV-7474.

---
 .../r/subselect_sj2_jcl6,innodb_plugin.rdiff       |    9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/mysql-test/r/subselect_sj2_jcl6,innodb_plugin.rdiff b/mysql-test/r/subselect_sj2_jcl6,innodb_plugin.rdiff
index c32f52f..bf2c369 100644
--- a/mysql-test/r/subselect_sj2_jcl6,innodb_plugin.rdiff
+++ b/mysql-test/r/subselect_sj2_jcl6,innodb_plugin.rdiff
@@ -9,3 +9,12 @@
  SELECT * FROM t2 
  WHERE (a, a) IN (SELECT alias2.b, alias2.a FROM t1 AS alias1, t1 AS alias2 
  WHERE 
+@@ -1272,7 +1272,7 @@
+ );
+ id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+ 1	PRIMARY	T3_0_	ref	PRIMARY,FK_T3_T2Id	PRIMARY	8	const	3	Using index; Start temporary
+-1	PRIMARY	T2_1_	eq_ref	PRIMARY,FK_T2_T1Id	PRIMARY	8	test.T3_0_.t2idref	1	Using join buffer (flat, BKA join); Key-ordered scan
++1	PRIMARY	T2_1_	eq_ref	PRIMARY,FK_T2_T1Id	PRIMARY	8	test.T3_0_.t2idref	1	
+ 1	PRIMARY	T1_1_	eq_ref	PRIMARY	PRIMARY	8	test.T2_1_.t1idref	1	Using index
+ 1	PRIMARY	T2_0_	ref	FK_T2_T1Id	FK_T2_T1Id	8	test.T2_1_.t1idref	1	Using index; End temporary
+ drop table t3,t2,t1;


More information about the commits mailing list