From f8c7e3477f17488f546ab5d20c4fad6aa0577d01 Mon Sep 17 00:00:00 2001 From: Sergey Petrunya Date: Mon, 30 Dec 2013 20:30:29 +0400 Subject: MDEV-5349: Test main.subselect_sj_jcl6 fails sporadically due to insufficient ordering - Add --sorted_result to the query --- mysql-test/t/subselect_sj.test | 1 + 1 file changed, 1 insertion(+) (limited to 'mysql-test/t/subselect_sj.test') diff --git a/mysql-test/t/subselect_sj.test b/mysql-test/t/subselect_sj.test index 536606175bb..a6ce3f25617 100644 --- a/mysql-test/t/subselect_sj.test +++ b/mysql-test/t/subselect_sj.test @@ -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: -- cgit v1.2.1