List:Commits« Previous MessageNext Message »
From:Jonas Oreland Date:August 26 2010 8:24am
Subject:bzr commit into mysql-5.1-telco-7.0-spj-scan-vs-scan branch (jonas:3248)
View as plain text  
#At file:///home/jonas/src/70-spj-svs/ based on revid:jonas@stripped

 3248 Jonas Oreland	2010-08-26
      ndb - add a few "big" result-set scan-vs-scan joins

    modified:
      mysql-test/suite/ndb/r/ndb_join_pushdown.result
      mysql-test/suite/ndb/t/ndb_join_pushdown.test
=== modified file 'mysql-test/suite/ndb/r/ndb_join_pushdown.result'
--- a/mysql-test/suite/ndb/r/ndb_join_pushdown.result	2010-08-26 08:20:17 +0000
+++ b/mysql-test/suite/ndb/r/ndb_join_pushdown.result	2010-08-26 08:24:31 +0000
@@ -2950,6 +2950,18 @@ join t1 as t2 on t2.a = t1.c and t2.b = 
 join t1 as t3 on t3.a = t2.c and t3.b = t2.d;
 count(*)
 2996
+select count(*)
+from t1
+join t1 as t2 on t2.a = t1.c
+join t1 as t3 on t3.a = t2.c and t3.b = t2.d;
+count(*)
+8990
+select count(*)
+from t1
+join t1 as t2 on t2.a = t1.c and t2.b = t1.d
+join t1 as t3 on t3.a = t2.c;
+count(*)
+8988
 drop table t1;
 CREATE LOGFILE GROUP lg1
 ADD UNDOFILE 'undofile.dat'

=== modified file 'mysql-test/suite/ndb/t/ndb_join_pushdown.test'
--- a/mysql-test/suite/ndb/t/ndb_join_pushdown.test	2010-08-26 08:20:17 +0000
+++ b/mysql-test/suite/ndb/t/ndb_join_pushdown.test	2010-08-26 08:24:31 +0000
@@ -1885,6 +1885,16 @@ from t1 
 join t1 as t2 on t2.a = t1.c and t2.b = t1.d
 join t1 as t3 on t3.a = t2.c and t3.b = t2.d;
 
+select count(*)
+from t1
+join t1 as t2 on t2.a = t1.c
+join t1 as t3 on t3.a = t2.c and t3.b = t2.d;
+
+select count(*)
+from t1
+join t1 as t2 on t2.a = t1.c and t2.b = t1.d
+join t1 as t3 on t3.a = t2.c;
+
 drop table t1;
 
 # Pushed join accessing disk data.


Attachment: [text/bzr-bundle] bzr/jonas@mysql.com-20100826082431-pfdv13n95af2gkah.bundle
Thread
bzr commit into mysql-5.1-telco-7.0-spj-scan-vs-scan branch (jonas:3248) Jonas Oreland26 Aug