Update of /cvsroot/monetdb/MonetDB5/src/optimizer/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv8766/Tests
Modified Files:
All JPexample.stable.out
Added Files:
replicator00.mal replicator00.stable.err
replicator00.stable.out
Log Message:
Addition of the skeleton for the replicator optimizer.
JPexample benefits from the joinpath optimizer
Index: JPexample.stable.out
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/optimizer/Tests/JPexample.stable.out,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- JPexample.stable.out 26 Sep 2006 06:14:15 -0000 1.1
+++ JPexample.stable.out 27 Jan 2008 11:11:06 -0000 1.2
@@ -32,9 +32,10 @@
j1 := algebra.join(a,b); # 5 ALGjoin
(j1:bat[:void,:oid])<-(a:bat[:void,:oid])(b:bat[:oid,:oid])
j2 := algebra.joinPath(a,b,c); # 6 ALGjoinPath
(j2:bat[:void,:str])<-(a:bat[:void,:oid])(b:bat[:oid,:oid])(c:bat[:oid,:str])
j3 := algebra.join(b,b); # 7 ALGjoin
(j3:bat[:oid,:oid])<-(b:bat[:oid,:oid])(b:bat[:oid,:oid])
- j4 := algebra.joinPath(b,b,b); # 8 ALGjoinPath
(j4:bat[:oid,:oid])<-(b:bat[:oid,:oid])(b:bat[:oid,:oid])(b:bat[:oid,:oid])
- mdb.list(); # 9 MDBlist (_13:void)
-end main; # 10
+ _14 := algebra.join(b,b); # 8 ALGjoin
(_14:bat[:oid,:oid])<-(b:bat[:oid,:oid])(b:bat[:oid,:oid])
+ j4 := algebra.join(_14,b); # 9 ALGjoin
(j4:bat[:oid,:oid])<-(_14:bat[:oid,:oid])(b:bat[:oid,:oid])
+ mdb.list(); # 10 MDBlist (_13:void)
+end main; # 11
function user.main():void;
# test the joinpath expander
a := bat.new(:void,:oid);
@@ -43,7 +44,8 @@
j1 := algebra.join(a,b);
j2 := algebra.joinPath(a,b,c);
j3 := algebra.join(b,b);
- j4 := algebra.joinPath(b,b,b);
+ _14 := algebra.join(b,b);
+ j4 := algebra.join(_14,b);
mdb.list();
end main;
Index: All
===================================================================
RCS file: /cvsroot/monetdb/MonetDB5/src/optimizer/Tests/All,v
retrieving revision 1.61
retrieving revision 1.62
diff -u -d -r1.61 -r1.62
--- All 25 Jan 2008 12:00:39 -0000 1.61
+++ All 27 Jan 2008 11:11:06 -0000 1.62
@@ -77,6 +77,8 @@
inlineIfthen
inlineCst
+replicator00
+
CXerror1
#the remainder are snippets used in the reference manual
CMexample
--- NEW FILE: replicator00.mal ---
#test the basics of the replicator
module sql;
function sql.bind(s:str,r:str,c:str):bat[:int,:int];
b:= bat.new(:int,:int);
return bind:= b;
end bind;
function qry();
b:bat[:int,:int]:= sql.bind("schema","r","t");
t:= algebra.select(b,1,10);
end qry;
optimizer.replicator("user","qry");
mdb.list("user","qry");
--- NEW FILE: replicator00.stable.err ---
stderr of test 'replicator00` in directory 'src/optimizer` itself:
# 12:06:27 >
# 12:06:27 > mserver5 "--config=/ufs/mk/monet5/Linux/etc/monetdb5.conf"
--debug=10 --set
"monet_mod_path=/ufs/mk/monet5//Linux/lib/MonetDB5:/ufs/mk/monet5//Linux/lib/MonetDB5/lib:/ufs/mk/monet5//Linux/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/mk/monet5//Linux/var/MonetDB5/dbfarm" --set
"sql_logdir=/ufs/mk/monet5//Linux/var/MonetDB5/sql_logs" --set mapi_open=true
--set xrpc_open=true --set mapi_port=31116 --set xrpc_port=45281 --set
monet_prompt= --trace --dbname=mTests_src_optimizer replicator00.mal
# 12:06:27 >
#warning: please don't forget to set your vault key!
#(see /ufs/mk/monet5/Linux/etc/monetdb5.conf)
# 12:06:28 >
# 12:06:28 > Done.
# 12:06:28 >
--- NEW FILE: replicator00.stable.out ---
stdout of test 'replicator00` in directory 'src/optimizer` itself:
# 12:06:27 >
# 12:06:27 > mserver5 "--config=/ufs/mk/monet5/Linux/etc/monetdb5.conf"
--debug=10 --set
"monet_mod_path=/ufs/mk/monet5//Linux/lib/MonetDB5:/ufs/mk/monet5//Linux/lib/MonetDB5/lib:/ufs/mk/monet5//Linux/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/mk/monet5//Linux/var/MonetDB5/dbfarm" --set
"sql_logdir=/ufs/mk/monet5//Linux/var/MonetDB5/sql_logs" --set mapi_open=true
--set xrpc_open=true --set mapi_port=31116 --set xrpc_port=45281 --set
monet_prompt= --trace --dbname=mTests_src_optimizer replicator00.mal
# 12:06:27 >
# MonetDB server v5.3.0, based on kernel v1.21.0
# Serving database 'mTests_src_optimizer'
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-2007 CWI, all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://gio.ins.cwi.nl:31116/
##test the basics of the replicator
#
#module sql;
#function sql.bind(s:str,r:str,c:str):bat[:int,:int];
# b:= bat.new(:int,:int);
# return bind:= b;
#end bind;
function sql.bind(s:str,r:str,c:str):bat[:int,:int]; # 0
(bind:bat[:int,:int])<-(s:str)(r:str)(c:str)
b := bat.new(:int,:int); # 1 CMDBATnew
(b:bat[:int,:int])<-(_5:int)(_5:int)
return bind := b; # 2 (bind:bat[:int,:int])<-(b:bat[:int,:int])
end bind; # 3
#
#function qry();
# b:bat[:int,:int]:= sql.bind("schema","r","t");
# t:= algebra.select(b,1,10);
#end qry;
function sql.qry():void; # 0 (qry:void)
b:bat[:int,:int] := sql.bind("schema","r","t"); # 1
(b:bat[:int,:int])<-(_2:str)(_3:str)(_4:str)
t := algebra.select(b,1,10); # 2 ALGselect
(t:bat[:int,:int])<-(b:bat[:int,:int])(_6:int)(_7:int)
end qry; # 3
#
#
#optimizer.replicator("user","qry");
#mdb.list("user","qry");
#
function user.main():void; # 0 (main:void)
#test the basics of the replicator # 1 (_1:str)
mdb.list("user","qry"); # 2 MDBlist3 (_5:void)<-(_3:str)(_4:str)
end main; # 3
function sql.qry():void;
b:bat[:int,:int] := sql.bind("schema","r","t");
replicator.prelude(b);
t := algebra.select(b,1,10);
replicator.postlude(t);
end qry;
# 12:06:28 >
# 12:06:28 > Done.
# 12:06:28 >
-------------------------------------------------------------------------
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
