Update of /cvsroot/monetdb/MonetDB5/src/mal/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8060
Modified Files:
All
Added Files:
recycle02.mal
Log Message:
And an example to re-use multiple statements
--- NEW FILE: recycle02.mal ---
#test the basics of the recycler
# re-use joins
function user.bind(s:str,t:str,c:str,i:int):bat[:oid,:int];
b:= bat.new(:oid,:int);
bat.insert(b,[EMAIL PROTECTED],0);
bat.insert(b,[EMAIL PROTECTED],1);
bat.insert(b,[EMAIL PROTECTED],2);
bat.insert(b,[EMAIL PROTECTED],3);
bat.insert(b,[EMAIL PROTECTED],4);
bat.insert(b,[EMAIL PROTECTED],5);
bat.insert(b,[EMAIL PROTECTED],6);
bat.insert(b,[EMAIL PROTECTED],7);
bat.insert(b,[EMAIL PROTECTED],8);
bat.insert(b,[EMAIL PROTECTED],9);
bat.insert(b,[EMAIL PROTECTED],10);
bat.insert(b,[EMAIL PROTECTED],11);
return bind:=b;
end bind;
function qry(low:int, hgh:int);
b:= user.bind("schema","table","column",0);
s1:= algebra.select(b,low,hgh);
m0:= algebra.markT(b, [EMAIL PROTECTED]);
mr:= bat.reverse(m0);
j:= algebra.join(mr,s1);
io.print(j);
end qry;
recycle.setRetainPolicy(1);
recycle.setReusePolicy(1);
optimizer.recycle("user","qry");
io.print("start");
qry(1,10);
io.print("zoom in");
qry(1,5);
io.print("next step");
qry(2,3);
io.print("last");
qry(1,11);
Index: All
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/mal/Tests/All,v
retrieving revision 1.93
retrieving revision 1.94
diff -u -d -r1.93 -r1.94
--- All 4 Mar 2008 09:20:09 -0000 1.93
+++ All 4 Mar 2008 20:24:59 -0000 1.94
@@ -224,4 +224,5 @@
recycle00
recycle01
+recycle02
venks
-------------------------------------------------------------------------
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
