Update of /cvsroot/monetdb/MonetDB5/src/optimizer/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv5560/optimizer/Tests
Modified Files:
tst4630.mal tst4630.stable.out
Log Message:
The joinpath optimizer now als implements a heurist for the
SQL frontend to re-use common join paths.
Index: tst4630.mal
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/optimizer/Tests/tst4630.mal,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -d -r1.6 -r1.7
--- tst4630.mal 25 Jan 2008 12:00:39 -0000 1.6
+++ tst4630.mal 27 Jan 2008 08:21:29 -0000 1.7
@@ -14,6 +14,6 @@
end qry;
optimizer.joinPath("user","qry");
-optimizer.deadcode("user","qry");
+optimizer.commonTerms("user","qry");
mdb.list("user","qry");
Index: tst4630.stable.out
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/optimizer/Tests/tst4630.stable.out,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- tst4630.stable.out 25 Jan 2008 14:19:59 -0000 1.9
+++ tst4630.stable.out 27 Jan 2008 08:21:29 -0000 1.10
@@ -48,11 +48,11 @@
mdb.list("user","qry"); # 3 MDBlist3 (_7:void)<-(_4:str)(_5:str)
end main; # 4
function
user.qry(a:bat[:any_1,:any_2],b:bat[:any_2,:any_3],c:bat[:any_3,:any_4]):bat[:any_1,:any_4];
- a1 := a;
- b1 := b;
- c1 := c;
z := algebra.join(a,b);
- xx := algebra.joinPath(z,a1,b1,c1);
+ zz := algebra.join(z,c);
+ ww := algebra.join(z,a);
+ yy := algebra.joinPath(z,a,b);
+ xx := algebra.joinPath(ww,b,c);
return qry := xx;
end qry;
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-checkins
