bzr commit into mysql-5.1-telco-7.0-spj-scan-vs-scan branch (ole.john.aske:3443)

[Ole John Aske]

#At file:///net/fimafeng09/export/home/tmp/oleja/mysql/mysql-5.1-telco-7.0-spj-scan-scan/ based on revid:jan.wedvik@stripped

 3443 Ole John Aske	2011-02-28
      A few query plans changed as result of merge from main telco containing 'greedy optimizer patches'.
      Added 'straight_join' to these testcases to make then produce the original query plan.
      (Which is critical for having the test to test what it was supposed to test)

    modified:
      mysql-test/suite/ndb/t/ndb_join_pushdown.test
=== modified file 'mysql-test/suite/ndb/t/ndb_join_pushdown.test'
--- a/mysql-test/suite/ndb/t/ndb_join_pushdown.test	2011-02-14 10:50:42 +0000
+++ b/mysql-test/suite/ndb/t/ndb_join_pushdown.test	2011-02-28 11:46:27 +0000
@@ -59,11 +59,11 @@ join t1 as t2 on t2.a = t1.b and t2.b = 
 # Check that we do not push an operation if this prevents us from using
 # 'join buffer'.
 explain extended 
-select count(*) 
+select straight_join count(*) 
 from t1 as x1 
 join t1 as x2 on x1.d > x2.a + 1000 
 join t1 as x3 on x1.c=x3.a and x1.d=x3.b;
-select count(*) 
+select straight_join count(*) 
 from t1 as x1 
 join t1 as x2 on x1.d > x2.a + 1000 
 join t1 as x3 on x1.c=x3.a and x1.d=x3.b;
@@ -2726,10 +2726,10 @@ update t1 set b=b-10;
 update t1 set u=u+100;
 
 set ndb_join_pushdown=on;
-explain extended select count(*) from 
+explain extended select straight_join count(*) from 
   (t1 as x join t1 as y on y.b = x.a)
  left outer join t1 as z on z.u = x.a;
-select count(*) from 
+select straight_join count(*) from 
   (t1 as x join t1 as y on y.b = x.a)
  left outer join t1 as z on z.u = x.a;
 


Attachment: [text/bzr-bundle] bzr/[e-mail]