[Commits] Rev 4009: MDEV-5349: Test main.subselect_sj_jcl6 fails sporadically due to insufficient ordering in file:///home/psergey/dev2/5.5/

Sergey Petrunya psergey at askmonty.org
Mon Dec 30 18:30:31 EET 2013


At file:///home/psergey/dev2/5.5/

------------------------------------------------------------
revno: 4009
revision-id: psergey at askmonty.org-20131230163029-emh4gtizkjqtpjou
parent: sergii at pisem.net-20131217162654-dw2zlm3td1p12bxl
committer: Sergey Petrunya <psergey at askmonty.org>
branch nick: 5.5
timestamp: Mon 2013-12-30 20:30:29 +0400
message:
  MDEV-5349: Test main.subselect_sj_jcl6 fails sporadically due to insufficient ordering
  - Add --sorted_result to the query
=== modified file 'mysql-test/r/subselect_sj.result'
--- a/mysql-test/r/subselect_sj.result	2013-11-21 09:35:20 +0000
+++ b/mysql-test/r/subselect_sj.result	2013-12-30 16:30:29 +0000
@@ -2931,10 +2931,10 @@ CREATE TABLE t3 (c3 VARCHAR(1)) ENGINE=M
 INSERT INTO t3 VALUES ('x'),('d');
 SELECT * FROM t1, t2 WHERE pk IN ( SELECT pk FROM t1 LEFT JOIN t3 ON (c1 = c3 ) ) ORDER BY c2, c1;
 pk	c1	c2
-4	NULL	x
-3	c	x
 1	v	x
 2	v	x
+3	c	x
+4	NULL	x
 5	x	x
 # This should show that "t1 left join t3" is still in the semi-join nest:
 EXPLAIN EXTENDED

=== modified file 'mysql-test/r/subselect_sj_jcl6.result'
--- a/mysql-test/r/subselect_sj_jcl6.result	2013-11-21 09:35:20 +0000
+++ b/mysql-test/r/subselect_sj_jcl6.result	2013-12-30 16:30:29 +0000
@@ -2945,10 +2945,10 @@ CREATE TABLE t3 (c3 VARCHAR(1)) ENGINE=M
 INSERT INTO t3 VALUES ('x'),('d');
 SELECT * FROM t1, t2 WHERE pk IN ( SELECT pk FROM t1 LEFT JOIN t3 ON (c1 = c3 ) ) ORDER BY c2, c1;
 pk	c1	c2
-4	NULL	x
-3	c	x
 1	v	x
 2	v	x
+3	c	x
+4	NULL	x
 5	x	x
 # This should show that "t1 left join t3" is still in the semi-join nest:
 EXPLAIN EXTENDED

=== modified file 'mysql-test/t/subselect_sj.test'
--- a/mysql-test/t/subselect_sj.test	2013-11-21 09:35:20 +0000
+++ b/mysql-test/t/subselect_sj.test	2013-12-30 16:30:29 +0000
@@ -2634,6 +2634,7 @@ INSERT INTO t2 VALUES ('x');
 CREATE TABLE t3 (c3 VARCHAR(1)) ENGINE=MyISAM;
 INSERT INTO t3 VALUES ('x'),('d');
 
+--sorted_result
 SELECT * FROM t1, t2 WHERE pk IN ( SELECT pk FROM t1 LEFT JOIN t3 ON (c1 = c3 ) ) ORDER BY c2, c1;
 
 --echo # This should show that "t1 left join t3" is still in the semi-join nest:



More information about the commits mailing list