- developers-list - monetdb.org

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/runtime/xrpc/admin/Tests add_del_doc.xq.in, Nov2008, 1.1.4.3, 1.1.4.4 add_del_doc_noxrpc.xq.in, Nov2008, 1.1.2.1, 1.1.2.2 add_trusted.mil, Nov2008, 1.1.4.2, 1.1.4.3 backup_restore.xq.in, Nov2008, 1.1.4.5, 1.1.4.6 backup_restore_noxrpc.xq.in, Nov2008, 1.1.2.2, 1.1.2.3 db_env.xq.in, Nov2008, 1.1.4.2, 1.1.4.3 db_env_noxrpc.xq.in, Nov2008, 1.1.2.1, 1.1.2.2 db_stats.xq.in, Nov2008, 1.1.4.2, 1.1.4.3 db_stats_noxrpc.xq.in, Nov2008, 1.1.2.1, 1.1.2.2
by Sjoerd Mullender 12 Jan '09

12 Jan '09

On 2009-01-12 17:16, Ying Zhang wrote: > Sorry, forgot to mention: please don't propagate these changes to HEAD! I took care of that. > Thanks. > > Jennie > > > On Mon, Jan 12, 2009 at 04:01:02PM +0000, Ying Zhang wrote: >> Update of /cvsroot/monetdb/pathfinder/runtime/xrpc/admin/Tests >> In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv10518 >> >> Modified Files: >> Tag: Nov2008 >> add_del_doc.xq.in add_del_doc_noxrpc.xq.in add_trusted.mil >> backup_restore.xq.in backup_restore_noxrpc.xq.in db_env.xq.in >> db_env_noxrpc.xq.in db_stats.xq.in db_stats_noxrpc.xq.in >> Log Message: >> - *.xq.in >> >> the xrpc http server is not available (yet) in RunMtest, hence, use the module >> file 'admin.xq'-s local path, instead of using its URL served by the xrpc http server. >> >> -add_trusted.mil >> >> allow 'admin.xq' to be executed >> >> >> >> U add_del_doc.xq.in >> Index: add_del_doc.xq.in >> =================================================================== >> RCS file: /cvsroot/monetdb/pathfinder/runtime/xrpc/admin/Tests/add_del_doc.xq.in,v >> retrieving revision 1.1.4.3 >> retrieving revision 1.1.4.4 >> diff -u -d -r1.1.4.3 -r1.1.4.4 >> --- add_del_doc.xq.in 9 Jan 2009 10:36:24 -0000 1.1.4.3 >> +++ add_del_doc.xq.in 12 Jan 2009 16:01:00 -0000 1.1.4.4 >> @@ -11,17 +11,17 @@ >> - adm:del-doc() >> :) >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> (execute at {"$HOST:$XRPCPORT"} >> - {adm:add-doc("http://$HOST:$XRPCPORT/admin/xmark1.xml", >> + {adm:add-doc("$TSTSRCBASE/runtime/xrpc/admin/xmark1.xml", >> "xmark1.xml", "xmark", 10)}, >> execute at {"$HOST:$XRPCPORT"} >> - {adm:add-doc("http://$HOST:$XRPCPORT/admin/xmark2.xml", >> + {adm:add-doc("$TSTSRCBASE/runtime/xrpc/admin/xmark2.xml", >> "xmark2.xml", "xmark", 10)} >> ) >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> ( >> text { "
 "}, >> <collections-after-add>{ >> @@ -61,11 +61,11 @@ >> ) >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> execute at {"$HOST:$XRPCPORT"} {adm:del-col("xmark")} >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> ( >> text { "
 "}, >> <collections-after-del>{ >> >> U backup_restore_noxrpc.xq.in >> Index: backup_restore_noxrpc.xq.in >> =================================================================== >> RCS file: /cvsroot/monetdb/pathfinder/runtime/xrpc/admin/Tests/backup_restore_noxrpc.xq.in,v >> retrieving revision 1.1.2.2 >> retrieving revision 1.1.2.3 >> diff -u -d -r1.1.2.2 -r1.1.2.3 >> --- backup_restore_noxrpc.xq.in 9 Jan 2009 14:40:24 -0000 1.1.2.2 >> +++ backup_restore_noxrpc.xq.in 12 Jan 2009 16:01:00 -0000 1.1.2.3 >> @@ -15,13 +15,13 @@ >> - adm:restore-col() >> :) >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> -(adm:add-doc("http://$HOST:$XRPCPORT/admin/xmark1.xml", "xmark1.xml", "xmark", 10), >> - adm:add-doc("http://$HOST:$XRPCPORT/admin/xmark2.xml", "xmark2.xml", "xmark", 10) >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> +(adm:add-doc("$TSTSRCBASE/runtime/xrpc/admin/xmark1.xml", "xmark1.xml", "xmark", 10), >> + adm:add-doc("$TSTSRCBASE/runtime/xrpc/admin/xmark2.xml", "xmark2.xml", "xmark", 10) >> ) >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> ( >> text {"
 "}, >> <db-before-backup>{ >> @@ -38,23 +38,23 @@ >> ) >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> adm:backup("test") >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> adm:del-col("xmark") >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> <db-after-del>{ adm:collections() }</db-after-del> >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> adm:restore("test", 10) >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> ( >> text {"
 "}, >> <db-after-restore>{ >> @@ -73,11 +73,11 @@ >> <> >> (: clean DB at the end of the test :) >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> adm:del-col("xmark") >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> <db-after-cleanup> >> { adm:documents() } >> </db-after-cleanup> >> >> U db_env_noxrpc.xq.in >> Index: db_env_noxrpc.xq.in >> =================================================================== >> RCS file: /cvsroot/monetdb/pathfinder/runtime/xrpc/admin/Tests/db_env_noxrpc.xq.in,v >> retrieving revision 1.1.2.1 >> retrieving revision 1.1.2.2 >> diff -u -d -r1.1.2.1 -r1.1.2.2 >> --- db_env_noxrpc.xq.in 9 Jan 2009 10:36:24 -0000 1.1.2.1 >> +++ db_env_noxrpc.xq.in 12 Jan 2009 16:01:00 -0000 1.1.2.2 >> @@ -4,7 +4,7 @@ >> Filter out uninteresting differences in the results >> :) >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> for $env in adm:db-env() >> return >> (text { "
 " }, >> >> U db_stats.xq.in >> Index: db_stats.xq.in >> =================================================================== >> RCS file: /cvsroot/monetdb/pathfinder/runtime/xrpc/admin/Tests/db_stats.xq.in,v >> retrieving revision 1.1.4.2 >> retrieving revision 1.1.4.3 >> diff -u -d -r1.1.4.2 -r1.1.4.3 >> --- db_stats.xq.in 18 Nov 2008 10:43:35 -0000 1.1.4.2 >> +++ db_stats.xq.in 12 Jan 2009 16:01:00 -0000 1.1.4.3 >> @@ -4,7 +4,7 @@ >> Filter out uninteresting differences in the results >> :) >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> for $stat in execute at {"$HOST:$XRPCPORT"} {adm:db-stats()} >> return >> (text { "
 " }, >> >> U add_del_doc_noxrpc.xq.in >> Index: add_del_doc_noxrpc.xq.in >> =================================================================== >> RCS file: /cvsroot/monetdb/pathfinder/runtime/xrpc/admin/Tests/add_del_doc_noxrpc.xq.in,v >> retrieving revision 1.1.2.1 >> retrieving revision 1.1.2.2 >> diff -u -d -r1.1.2.1 -r1.1.2.2 >> --- add_del_doc_noxrpc.xq.in 9 Jan 2009 10:36:24 -0000 1.1.2.1 >> +++ add_del_doc_noxrpc.xq.in 12 Jan 2009 16:01:00 -0000 1.1.2.2 >> @@ -11,13 +11,13 @@ >> - adm:del-doc() >> :) >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> -(adm:add-doc("http://$HOST:$XRPCPORT/admin/xmark1.xml", "xmark1.xml", "xmark", 10), >> - adm:add-doc("http://$HOST:$XRPCPORT/admin/xmark2.xml", "xmark2.xml", "xmark", 10) >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> +(adm:add-doc("$TSTSRCBASE/runtime/xrpc/admin/xmark1.xml", "xmark1.xml", "xmark", 10), >> + adm:add-doc("$TSTSRCBASE/runtime/xrpc/admin/xmark2.xml", "xmark2.xml", "xmark", 10) >> ) >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> ( >> text { "
 "}, >> <collections-after-add>{ >> @@ -57,11 +57,11 @@ >> ) >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> adm:del-col("xmark") >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> ( >> text { "
 "}, >> <collections-after-del>{ >> >> U db_stats_noxrpc.xq.in >> Index: db_stats_noxrpc.xq.in >> =================================================================== >> RCS file: /cvsroot/monetdb/pathfinder/runtime/xrpc/admin/Tests/db_stats_noxrpc.xq.in,v >> retrieving revision 1.1.2.1 >> retrieving revision 1.1.2.2 >> diff -u -d -r1.1.2.1 -r1.1.2.2 >> --- db_stats_noxrpc.xq.in 9 Jan 2009 10:36:24 -0000 1.1.2.1 >> +++ db_stats_noxrpc.xq.in 12 Jan 2009 16:01:00 -0000 1.1.2.2 >> @@ -4,7 +4,7 @@ >> Filter out uninteresting differences in the results >> :) >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> for $stat in adm:db-stats() >> return >> (text { "
 " }, >> >> U db_env.xq.in >> Index: db_env.xq.in >> =================================================================== >> RCS file: /cvsroot/monetdb/pathfinder/runtime/xrpc/admin/Tests/db_env.xq.in,v >> retrieving revision 1.1.4.2 >> retrieving revision 1.1.4.3 >> diff -u -d -r1.1.4.2 -r1.1.4.3 >> --- db_env.xq.in 18 Nov 2008 10:43:35 -0000 1.1.4.2 >> +++ db_env.xq.in 12 Jan 2009 16:01:00 -0000 1.1.4.3 >> @@ -4,7 +4,7 @@ >> Filter out uninteresting differences in the results >> :) >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> for $env in execute at {"$HOST:$XRPCPORT"} {adm:db-env()} >> return >> (text { "
 " }, >> >> U add_trusted.mil >> Index: add_trusted.mil >> =================================================================== >> RCS file: /cvsroot/monetdb/pathfinder/runtime/xrpc/admin/Tests/add_trusted.mil,v >> retrieving revision 1.1.4.2 >> retrieving revision 1.1.4.3 >> diff -u -d -r1.1.4.2 -r1.1.4.3 >> --- add_trusted.mil 18 Nov 2008 10:43:35 -0000 1.1.4.2 >> +++ add_trusted.mil 12 Jan 2009 16:01:00 -0000 1.1.4.3 >> @@ -2,12 +2,17 @@ >> module("unix"); >> >> var TSTSRCDIR := getenv("TSTSRCDIR"); >> +var TSTSRCBASE := getenv("TSTSRCBASE"); >> var TSTTRGDIR := getenv("TSTTRGDIR"); >> +var TSTTRGBASE := getenv("TSTTRGBASE"); >> var HOST := getenv("HOST"); >> var XRPCPORT := getenv("XRPCPORT"); >> >> add_xrpc_trusted(TSTSRCDIR); >> +add_xrpc_trusted(TSTSRCBASE); >> + >> add_xrpc_trusted(TSTTRGDIR); >> +add_xrpc_trusted(TSTTRGBASE); >> add_xrpc_trusted("http://"+HOST+":"+XRPCPORT); >> >> commit(); >> >> U backup_restore.xq.in >> Index: backup_restore.xq.in >> =================================================================== >> RCS file: /cvsroot/monetdb/pathfinder/runtime/xrpc/admin/Tests/backup_restore.xq.in,v >> retrieving revision 1.1.4.5 >> retrieving revision 1.1.4.6 >> diff -u -d -r1.1.4.5 -r1.1.4.6 >> --- backup_restore.xq.in 9 Jan 2009 14:40:24 -0000 1.1.4.5 >> +++ backup_restore.xq.in 12 Jan 2009 16:01:00 -0000 1.1.4.6 >> @@ -15,17 +15,17 @@ >> - adm:restore-col() >> :) >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> (execute at {"$HOST:$XRPCPORT"} >> - {adm:add-doc("http://$HOST:$XRPCPORT/admin/xmark1.xml", >> + {adm:add-doc("$TSTSRCBASE/runtime/xrpc/admin/xmark1.xml", >> "xmark1.xml", "xmark", 10)}, >> execute at {"$HOST:$XRPCPORT"} >> - {adm:add-doc("http://$HOST:$XRPCPORT/admin/xmark2.xml", >> + {adm:add-doc("$TSTSRCBASE/runtime/xrpc/admin/xmark2.xml", >> "xmark2.xml", "xmark", 10)} >> ) >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> ( >> text {"
 "}, >> <db-before-backup>{ >> @@ -42,25 +42,25 @@ >> ) >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> execute at {"$HOST:$XRPCPORT"} {adm:backup("test")} >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> execute at {"$HOST:$XRPCPORT"} {adm:del-col("xmark")} >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> <db-after-del>{ >> execute at {"$HOST:$XRPCPORT"} {adm:collections()} >> }</db-after-del> >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> execute at {"$HOST:$XRPCPORT"} {adm:restore("test", 10)} >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> ( >> text {"
 "}, >> <db-after-restore>{ >> @@ -79,11 +79,11 @@ >> <> >> (: clean DB at the end of the test :) >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> execute at {"$HOST:$XRPCPORT"} {adm:del-col("xmark")} >> <> >> import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" >> - at "http://$HOST:$XRPCPORT/admin/admin.xq"; >> + at "$TSTSRCBASE/runtime/xrpc/admin/admin.xq"; >> <db-after-cleanup> >> { execute at {"$HOST:$XRPCPORT"} {adm:documents()} } >> </db-after-cleanup> >> >> >> ------------------------------------------------------------------------------ >> Check out the new SourceForge.net Marketplace. >> It is the best place to buy or sell services for >> just about anything Open Source. >> http://p.sf.net/sfu/Xq1LFB >> _______________________________________________ >> Monetdb-pf-checkins mailing list >> Monetdb-pf-checkins(a)lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by: > SourcForge Community > SourceForge wants to tell your story. > http://p.sf.net/sfu/sf-spreadtheword > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins -- Sjoerd Mullender

1 0

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/compiler/Tests usage.stable.out, , 1.19, 1.20 usageH.stable.out, , 1.49, 1.50
by Stefan Manegold 09 Jan '09

09 Jan '09

On Fri, Jan 09, 2009 at 09:50:35AM +0000, Jan Rittinger wrote: > Update of /cvsroot/monetdb/pathfinder/compiler/Tests > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv17274/Tests > > Modified Files: > usage.stable.out usageH.stable.out > Log Message: > -- Adjust help messages to the new copyright information. Just for info for you and for who ever will take care of updating the stable output accordingly in the Nov2008 release branch and then (not) propagating it to the development trunk (most probably Sjoerd or me ...): The copyright information has obviously also been updated in the Nov2008 release branch, and the stable output for the respective tests should be updated there as well --- propagating these updates *might* then cause (probably easily resolvable) conflicts as the stable output in the development trunk has just experienced two changes: new copyright and new usage info. Note, this is neither a critique nor a major problem, but just to share information that might help to reduce / prevent inconveniences, in particular with (semi-automa[tgn]ic) propagation of chnages from the latest release branch to the development trunk. (For the future, the "ideal" procedure would (have) be(en) to first update the copyright info in the stable output of the release branch, then propagate these changes, and then update / extend the usage info in the development trunk and update the stable output there accordingly. ;-)) Stefan > -- Extend help message 'pf -H' to list all available optimization phases. > > > U usageH.stable.out > Index: usageH.stable.out > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/compiler/Tests/usageH.stable.out,v > retrieving revision 1.49 > retrieving revision 1.50 > diff -u -d -r1.49 -r1.50 > --- usageH.stable.out 2 Dec 2008 17:30:41 -0000 1.49 > +++ usageH.stable.out 9 Jan 2009 09:50:33 -0000 1.50 > @@ -11,7 +11,7 @@ > # 15:43:45 > > > Pathfinder XQuery Compiler ($Revision$, $Date$) > -(c) Database Group, Technische Universitaet Muenchen > +(c) Database Systems Group, Eberhard Karls Universitaet Tuebingen > > Usage: pf [OPTION] [FILE] > > @@ -38,6 +38,9 @@ > = -p, --physical-algebra-plan: enable generation of physical algebra plan > = -f<format>, --format=<format>: enable generation of algebra properties > + print all available properties (logical/physical algebra) > + <optoptions> selectively choose optimization options that are based > + on a single property (e.g., 'O') to print the respective > + property > c print cost value (physical algebra) > o print orderings (physical algebra) > > @@ -65,23 +68,30 @@ > 21 after compiling the physical algebra into MIL code > 22 after the MIL program has been serialized > > -= -o<options>, --optimize-algebra=<options>: optimize algebra according to options: > += -o<optoptions>, --optimize-algebra=<optoptions>: optimize algebra according to optimization options: > + E merge common subexpressions (CSE) > + G apply general optimization (without properties) > O apply optimization based on constant property > I apply optimization based on icols property > K apply optimization based on key property > - C apply optimization using multiple properties (complex) > - (and icols based optimization will be applied afterwards) > - G apply general optimization (without properties) > + N apply optimization based on required node values property > V apply optimization based on required values property > - [ map column names to unique column names > - J push down equi-joins (requires unique column names) > - ] map column names back (from unique names to original names) > - M apply optimization based on multi-value dependencies > S apply optimization based on set property > + U apply optimization based on XML Guide information > + (only works for the SQL code generation) > + C apply optimization using multiple properties (complex) > + (and icols based optimization will be applied afterwards) > + J push down equi-joins > + M push up cross products (based on multi-value dependencies > + T push up theta-joins (based on multi-value dependencies > + R push up rank operators > } introduce proxy operators that representoperator groups > { remove proxy operators > + Q apply optimizations tailored for the SQL code generation > + [ assign a new set of unique column names > + ] assign bit-encoded column names (deprecated optimization option) > P infer all properties > - _ does nothing (used for structuring the options) > + _ does nothing (used for structuring the optimization options) > (default for option -A is: '-o OIKCG_VG_JISI_GECSVR_OK_N}MT{JISI_GECSVR_}MT{JISI_OK_GECSVR_GP') > (default for option -S is: '-o OIKCG_VG_JISI_GECSVR_OK_N}MT{JISI_GECSVR_Q_}MT{JISI_OK_GECSVR_QGP') > > > U usage.stable.out > Index: usage.stable.out > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/compiler/Tests/usage.stable.out,v > retrieving revision 1.19 > retrieving revision 1.20 > diff -u -d -r1.19 -r1.20 > --- usage.stable.out 19 Jun 2008 14:13:10 -0000 1.19 > +++ usage.stable.out 9 Jan 2009 09:50:33 -0000 1.20 > @@ -11,7 +11,7 @@ > # 13:16:47 > > > Pathfinder XQuery Compiler ($Revision$, $Date$) > -(c) Database Group, Technische Universitaet Muenchen > +(c) Database Systems Group, Eberhard Karls Universitaet Tuebingen > > Usage: pf [OPTION] [FILE] > > > > ------------------------------------------------------------------------------ > Check out the new SourceForge.net Marketplace. > It is the best place to buy or sell services for > just about anything Open Source. > http://p.sf.net/sfu/Xq1LFB > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins > > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

1 0

Re: [Monetdb-developers] [MonetDB-users] COPY INTO on aggregate queries crashes MonetDB
by Martin Kersten 04 Jan '09

04 Jan '09

Dear Peter, The problem mentioned could be reproduced. It is clearly a bug and registered as such in test copy-count.SF-2485215.sql. It seems a bug in the code generator of SQL. The progress can be followed in the sourceforge bugtracker. Thanks for using the MonetDB package and helping to improve its quality. regards, Martin Peter Farkash wrote: > Hi, > > When I use COPY INTO with a count query, monetDB crashes. > For example: > > copy select count (*) into 'C:\\copyinto.txt' using delimiters ','; > > Gives me the following result and kills the server: > > MAPI = monetdb@localhost:50000 > ACTION= read_line > QUERY = copy select count (*) into 'C:\\copyinto.txt' using delimiters ','; > ERROR = Connection terminated > > The same happens if I use sum, average, etc. On normal queries the copy into > works just fine. > I am using v5.8.2, and am getting the crash both when using mclient and the > MAPI programming interface. > > Any ideas? >

1 0

[Monetdb-developers] MonetDB at Ohloh
by Marcin Zukowski 03 Jan '09

03 Jan '09

Dear MonetDB Devs, As a pre-xmas present, I wanted to update MonetDB site on Ohloh.net - a site that has an ambition (and maybe a chance) to become a central information repository about FOSS projects and developers: https://www.ohloh.net/p/10306 Unfortunately, the code-analysis part of the site does not seem to like the 'sql' module, as it hangs during checking out its history: https://www.ohloh.net/p/10306/enlistments I contacted the Ohloh team, and it seems the error occurs at the following command: ~$ cvsnt -d :pserver:anonymous:@monetdb.cvs.sourceforge.net:/cvsroot/monetdb checkout -D'2001/06/07 13:41:21Z' -A -d'monetdb' 'sql' cvs checkout: Updating monetdb ... cvs [checkout aborted]: invalid change text in /cvsroot/monetdb/sql/src/odbc/driver/Attic/statement_dump.c,v If you think being properly visible on Ohloh is worth it, perhaps this is something some local CVS expert could investigate ;) Otherwise, we can remove the 'sql' module and hope the other ones work properly. cheers, Marcin

3 3

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/Skyserver Skyserver_import.sql, , 1.3, 1.4 Skyserver_tables.sql, , 1.4, 1.5
by Stefan Manegold 29 Dec '08

29 Dec '08

On Mon, Dec 29, 2008 at 04:50:00PM +0000, Romulo Goncalves wrote: > Update of /cvsroot/monetdb/sql/src/test/Skyserver > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv383 > > Modified Files: > Skyserver_import.sql Skyserver_tables.sql > Log Message: > Correct some copy from statements to make the test green > At the same time remove some NULL constraints from the columns because "" is now seen as NULL IMHO, "" (i.e., an empty string of length 0) is *not* NULL --- but I don't know, whether the SQL standard has a different "opinion" ... Stefan > > > > U Skyserver_tables.sql > Index: Skyserver_tables.sql > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_tables.sql,v > retrieving revision 1.4 > retrieving revision 1.5 > diff -u -d -r1.4 -r1.5 > --- Skyserver_tables.sql 1 Apr 2008 11:45:51 -0000 1.4 > +++ Skyserver_tables.sql 29 Dec 2008 16:49:58 -0000 1.5 > @@ -451,7 +451,7 @@ > eta float NOT NULL, > lambdaMin float NOT NULL, > lambdaMax float NOT NULL, > - htmArea varchar(1024) NOT NULL, > + htmArea varchar(1024), --NOT NULL, > CONSTRAINT pk_StripeDefs_stripe PRIMARY KEY > ( > stripe > @@ -1155,11 +1155,11 @@ > ); > CREATE TABLE DBColumns( > tablename varchar(128) NOT NULL, > - name varchar(64) NOT NULL, > - unit varchar(64) NOT NULL, > - ucd varchar(128) NOT NULL, > - enum varchar(64) NOT NULL, > - description varchar(2000) NOT NULL, > + name varchar(64), -- NOT NULL, > + unit varchar(64), -- NOT NULL, > + ucd varchar(128), --NOT NULL, > + enum varchar(64), -- NOT NULL, > + description varchar(2000),-- NOT NULL, > rank int NOT NULL DEFAULT (0), > CONSTRAINT pk_DBColumns_tableName_name PRIMARY KEY > ( > > U Skyserver_import.sql > Index: Skyserver_import.sql > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/Skyserver/Skyserver_import.sql,v > retrieving revision 1.3 > retrieving revision 1.4 > diff -u -d -r1.3 -r1.4 > --- Skyserver_import.sql 6 Jun 2008 11:54:58 -0000 1.3 > +++ Skyserver_import.sql 29 Dec 2008 16:49:58 -0000 1.4 > @@ -60,7 +60,7 @@ > > COPY 1000 RECORDS INTO SDSSConstants FROM 'DATA/SDSSConstants1.dat.bz2' USING DELIMITERS '|', '\015\n'; > > -COPY 1000 RECORDS INTO StripeDefs FROM 'DATA/StripeDefs1.dat.bz2' USING DELIMITERS '\t', '\015\n'; > +COPY 1000 RECORDS INTO StripeDefs FROM 'DATA/StripeDefs1.dat.bz2' USING DELIMITERS '\t', '\015\n', '"' NULL as ''; > > COPY 1000 RECORDS INTO RunShift FROM 'DATA/RunShift.dat.bz2' USING DELIMITERS '\t', '\015\n'; > > @@ -116,7 +116,7 @@ > > COPY 1000 RECORDS INTO Inventory FROM 'DATA/Inventory.dat.bz2' USING DELIMITERS '\t', '\015\n'; > > -COPY 3000 RECORDS INTO DBColumns FROM 'DATA/DBColumns1.dat.bz2' USING DELIMITERS '\t', '\015\n'; > +COPY 3000 RECORDS INTO DBColumns FROM 'DATA/DBColumns1.dat.bz2' USING DELIMITERS '\t', '\015\n', '"' NULL as ''; > > COPY 1000 RECORDS INTO DBViewCols FROM 'DATA/DBViewCols.dat.bz2' USING DELIMITERS '\t', '\015\n'; > > > > ------------------------------------------------------------------------------ > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

2 1

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/server sql_schema.mx, Nov2008, 1.152.2.1, 1.152.2.2
by Stefan Manegold 27 Dec '08

27 Dec '08

On Sat, Dec 27, 2008 at 05:08:39PM +0000, Romulo Goncalves wrote: > Update of /cvsroot/monetdb/sql/src/server > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv19272 > > Modified Files: > Tag: Nov2008 > sql_schema.mx > Log Message: > It seems it is also broken in the stable... > If you drop a constraint like a primary key make sure there are no dependencies on it... > > Note: Do not propagate this check in... it was already done in the current branch... if the changes are identical (i.e., made using cvs commands), propagation will notice this and silently accept the identical changes (i.e., not try to do them again). see also `man cvs` and pages 8-16 (in particular pages 13-15) of http://homepages.cwi.nl/~manegold/Presentations/MonetDBdevTTT.pdf Stefan > > U sql_schema.mx > Index: sql_schema.mx > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/server/sql_schema.mx,v > retrieving revision 1.152.2.1 > retrieving revision 1.152.2.2 > diff -u -d -r1.152.2.1 -r1.152.2.2 > --- sql_schema.mx 14 Nov 2008 13:48:40 -0000 1.152.2.1 > +++ sql_schema.mx 27 Dec 2008 17:08:37 -0000 1.152.2.2 > @@ -1695,6 +1695,8 @@ > assert(l->h->next->type == type_int); > if ((key = mvc_bind_key(sql, ss, kname )) == NULL) > return sql_error(sql, 02, "cannot drop unknown constraint %s\n", kname); > + if (!drop_action && mvc_check_dependency(sql, key->base.id, KEY_DEPENDENCY, NULL)) > + return sql_error(sql, 02, "unable to drop constraint %s (there are database objects which depend on it)\n", key->base.name); > mvc_drop_key(sql, ss, key, drop_action); > res = stmt_none(); > } break; > > > ------------------------------------------------------------------------------ > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins > > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

2 2

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/tests/StandOff StandOff.py, , 1.10, 1.11
by Stefan Manegold 23 Dec '08

23 Dec '08

Wouter, On Tue, Dec 23, 2008 at 10:40:57AM +0000, Wouter Alink wrote: > Update of /cvsroot/monetdb/pathfinder/tests/StandOff > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv29912 > > Modified Files: > StandOff.py > Log Message: > - this commit switches StandOff testing towards Algebra-backend was/is it you intension to force all StandOff testing though the Algebra back-end (added "-A" option for pf; see below), i.e., ignoring/overruling the compile time default / choice (whch is indeed the Algebra back-end) as well as the choice on the Mtest.py command line? If so, why? Does MPS not longer support StandOff (or v.v.)? If not, you should remove the "-A" swicth for pf, again. > - observation: order of attributes seems to have changed in some > tests, the testoutput has been changed accordingly Serialization in MonetDB/XQuery has not feature (yet?) to enforce a particular attribute order. The order of attributes is only determined by the very implementation and (physical) order of input data, and can hence change. If it happens to differe between the MPS & ALG back-end for (some) StandOff tests, we could consider approving back-end specific (ALG or MPS) stable output for these tests. (See `Mtest.py --help` and/or http://monetdb.cwi.nl/Development/TestWeb/Mtest/ for details and/or feel free to ask for advice/help.) Stefan > - the "video/artists" test still fails, due to incorrect order > of the elements in the result. this test needs more investigation > > > U StandOff.py > Index: StandOff.py > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/tests/StandOff/StandOff.py,v > retrieving revision 1.10 > retrieving revision 1.11 > diff -u -d -r1.10 -r1.11 > --- StandOff.py 15 Feb 2008 18:34:11 -0000 1.10 > +++ StandOff.py 23 Dec 2008 10:40:55 -0000 1.11 > @@ -27,7 +27,7 @@ > TSTSRCDIR = os.environ['TSTSRCDIR'] > PF = os.environ['PF'] > > -CALL = '%s -b "%s.xq" | %s --set standoff=enabled --dbname=%s "--dbinit=module(pathfinder);"' % (PF,os.path.join(TSTSRCDIR,TST),MSERVER,TSTDB) > +CALL = '%s -bA "%s.xq" | %s --set standoff=enabled --dbname=%s "--dbinit=module(pathfinder);"' % (PF,os.path.join(TSTSRCDIR,TST),MSERVER,TSTDB) > > import sys, time > Mlog = "\n%s %s\n\n" % (time.strftime('# %H:%M:%S >',time.localtime(time.time())), CALL) > > > ------------------------------------------------------------------------------ > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins > > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

3 4

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/compiler/semantics typecheck.brg, , 1.73, 1.74
by Stefan Manegold 22 Dec '08

22 Dec '08

Hi Wouter, thank you very much for porting your StandOff extensions to the Algebra back-end! I took this as a trigger to disable to automatic fall-back to the (deprecated) "milprint_summer" back-end in case the StandOff extensions are enabled (cf., http://monetdb.cwi.nl/Development/Releases/Version4.24/index.html#XQuery) The result: ======== .../pathfinder $ Mtest.py -rq --no-algebra tests/StandOff ................ ======== .../pathfinder $ Mtest.py -rq --algebra tests/StandOff .... * (test2.test.out.FILTERED) significantly .. * (lltest.test.out.FILTERED) significantly ........ * (scenes.test.out.FILTERED) significantly .. * (artists.test.out.FILTERED) significantly !ERROR: Testing FAILED SIGNIFICANTLY ! 4 out of 16 tests produced SIGNIFICANTLY different output ======== .../pathfinder $ Mtest.py -rq tests/StandOff .... * (test2.test.out.FILTERED) significantly .. * (lltest.test.out.FILTERED) significantly ........ * (scenes.test.out.FILTERED) significantly .. * (artists.test.out.FILTERED) significantly !ERROR: Testing FAILED SIGNIFICANTLY ! 4 out of 16 tests produced SIGNIFICANTLY different output ======== ;-) Stefan On Sun, Dec 21, 2008 at 07:33:36PM +0000, Wouter Alink wrote: > Update of /cvsroot/monetdb/pathfinder/compiler/semantics > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv21308/semantics > > Modified Files: > typecheck.brg > Log Message: > Step 3 of: > - enabling the standoff axes with the algebra backend. > - removing the "reject-narrow" and "reject-wide" axes steps > > In this commit: > - changes to the compiler. > > > > U typecheck.brg > Index: typecheck.brg > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/compiler/semantics/typecheck.brg,v > retrieving revision 1.73 > retrieving revision 1.74 > diff -u -d -r1.73 -r1.74 > --- typecheck.brg 14 Nov 2008 14:39:48 -0000 1.73 > +++ typecheck.brg 21 Dec 2008 19:33:33 -0000 1.74 > @@ -138,10 +138,8 @@ > %term preceding_sibling = 51 /**< all preceding nodes with same parent */ > %term self = 52 /**< the context node itself */ > /* [STANDOFF] */ > -%term select_narrow = 100 /**< regions contained in a context-node */ > -%term select_wide = 101 /**< regions overlapping a context-node */ > -%term reject_narrow = 102 /**< all regions except the contained regions */ > -%term reject_wide = 103 /**< all regions except the overlapping regions */ > +%term select_narrow = 53 /**< regions contained in a context-node */ > +%term select_wide = 54 /**< regions overlapping a context-node */ > /* [/STANDOFF] */ > > /* Constructor Nodes */ > @@ -228,10 +226,8 @@ > LocationStep: preceding_sibling (SequenceType) = 36 (10); > LocationStep: self (SequenceType) = 37 (10); > /* [STANDOFF] */ > -LocationStep: select_narrow (SequenceType) = 100 (10); > -LocationStep: select_wide (SequenceType) = 101 (10); > -LocationStep: reject_narrow (SequenceType) = 102 (10); > -LocationStep: reject_wide (SequenceType) = 103 (10); > +LocationStep: select_narrow (SequenceType) = 38 (10); > +LocationStep: select_wide (SequenceType) = 39 (10); > /* [/STANDOFF] */ > > LocationSteps: locsteps (LocationStep, LocationSteps) = 40 (10); > @@ -884,23 +880,13 @@ > TY(p) = TY(L(p)); > break; > /* [STANDOFF] */ > - case 100: > + case 38: > /* LocationStep: select_narrow (SequenceType) */ > TY(p) = PFty_star (TY(L(p))); > break; > > /* LocationStep: select_wide (SequenceType) */ > - case 101: > - TY(p) = PFty_star (TY(L(p))); > - break; > - > - /* LocationStep: reject_narrow (SequenceType) */ > - case 102: > - TY(p) = PFty_star (TY(L(p))); > - break; > - > - /* LocationStep: reject_wide (SequenceType) */ > - case 103: > + case 39: > TY(p) = PFty_star (TY(L(p))); > break; > /* [/STANDOFF] */ > > > ------------------------------------------------------------------------------ > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

1 0

[Monetdb-developers] Announcement: New bug fix release of MonetDB suite
by Sjoerd Mullender 22 Dec '08

22 Dec '08

The MonetDB team at CWI is pleased to announce the Nov2008-SP1 bug fix release of the MonetDB suite of programs. This is a bug fix release of last month's Nov2008 release. More information on this release can be found at <http://monetdb.cwi.nl/projects/monetdb/Development/Releases/Nov2008/#Nov200…>. The sources and binaries are available at <http://monetdb.cwi.nl/projects/monetdb/Download/>. -- Sjoerd Mullender

1 0

[Monetdb-developers] stable branch open
by Sjoerd Mullender 18 Dec '08

18 Dec '08

The release has been built. The stable branch is open again for business. Bug fixes only! -- Sjoerd Mullender

1 0