From: Sergey Petrunia Date: February 19 2009 10:51am Subject: bzr commit into mysql-6.0 branch (sergefp:2719) Bug#42585 List-Archive: http://lists.mysql.com/commits/66879 X-Bug: 42585 Message-Id: <20090219105100.3821D2EA062@pslp2.localdomain> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7BIT #At file:///home/spetrunia/dev/mysql-6.0-opt-fix/ based on revid:serg@stripped 2719 Sergey Petrunia 2009-02-19 BUG#42585: main.join_cache fails on powermacg5 - Make testcase stable modified: mysql-test/t/join_cache.test per-file messages: mysql-test/t/join_cache.test BUG#42585: main.join_cache fails on powermacg5 - Make testcase stable === modified file 'mysql-test/t/join_cache.test' --- a/mysql-test/t/join_cache.test 2009-02-12 00:02:09 +0000 +++ b/mysql-test/t/join_cache.test 2009-02-19 10:50:48 +0000 @@ -1083,6 +1083,7 @@ SELECT t1.a, t2.a, t3.a, t2.b, t3.b, t3. FROM (t1,t2) LEFT JOIN t3 ON (t1.a=t3.a AND t2.b=t3.b) WHERE t1.a=t2.a; +--sorted_result SELECT t1.a, t2.a, t3.a, t2.b, t3.b, t3.val FROM (t1,t2) LEFT JOIN t3 ON (t1.a=t3.a AND t2.b=t3.b) WHERE t1.a=t2.a;