Update of /cvsroot/monetdb/MonetDB5/src/mal/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv19319/Tests
Modified Files:
recycle01.mal
Log Message:
Re-use of ranges has been implemented and tested against example recycler01.
Index: recycle01.mal
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/mal/Tests/recycle01.mal,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- recycle01.mal 4 Mar 2008 09:20:09 -0000 1.1
+++ recycle01.mal 4 Mar 2008 14:52:46 -0000 1.2
@@ -2,7 +2,20 @@
# reusing select results
function user.bind(s:str,t:str,c:str,i:int):bat[:oid,:int];
- return bat.new(: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);
@@ -11,11 +24,13 @@
end qry;
recycle.setRetainPolicy(1);
-recycle.setReusePolicy(2);
+recycle.setReusePolicy(1);
optimizer.recycle("user","qry");
io.print("start");
qry(1,10);
-io.print("next");
+io.print("zoom in");
qry(1,5);
+io.print("next step");
+qry(2,3);
io.print("last");
-qry(2,6);
+qry(1,11);
-------------------------------------------------------------------------
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
