September 2007 - developers-list

[Monetdb-developers] Release preparations: Please refrain from checkins!
by Stefan Manegold 18 Sep '07

18 Sep '07

Dear MonetDB developers, Sjoerd and me are busing preparing for the upcoming release. The next step will be to create the new release branches. To ensure a smooth progress of the next step(s), and to avoid conflicts, we kindly ask you to refrain from ANY checkins to ANY MonetDB CVS repositories as of NOW until we notify you that checkins are allowed, again. Thank you very much for your cooperation! Stefan -- | 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 2

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/compiler/Tests pf-A_XMark.stable.err, , 1.1, 1.2 pf-A_XMark.stable.out, , 1.1, 1.2 pf-M_XMark.stable.err, , 1.6, 1.7 pf-M_XMark.stable.out, , 1.6, 1.7 usage.stable.out, , 1.15, 1.16 usageH.stable.out, , 1.34, 1.35
by Stefan Manegold 18 Sep '07

18 Sep '07

Oops! Peter, was this approval of error messages intended??? ( see also [ 1760459 ] PF/alg: tests fails since 2007/07/11 http://sourceforge.net/tracker/index.php?func=detail&aid=1760459&group_id=5… ) If not, please undo your (unintended) changes. In many cases, conveniences of `cvs diff` have proven very useful to check/verify one's changes before checking them in... Stefan On Tue, Sep 18, 2007 at 01:32:29PM +0000, Peter Boncz wrote: > Update of /cvsroot/monetdb/pathfinder/compiler/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv12888/compiler/Tests > > Modified Files: > pf-A_XMark.stable.err pf-A_XMark.stable.out > pf-M_XMark.stable.err pf-M_XMark.stable.out usage.stable.out > usageH.stable.out > Log Message: > - approving correct test results > > > > Index: pf-A_XMark.stable.err > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/compiler/Tests/pf-A_XMark.stable.err,v > retrieving revision 1.1 > retrieving revision 1.2 > diff -u -d -r1.1 -r1.2 > --- pf-A_XMark.stable.err 28 Dec 2005 17:04:06 -0000 1.1 > +++ pf-A_XMark.stable.err 18 Sep 2007 13:32:25 -0000 1.2 > @@ -5,6 +5,16 @@ > # 16:36:51 > Mtimeout -timeout 60 ./pf-A_XMark pf-A_XMark > # 16:36:51 > > > +"pf -A ff.xq >/dev/null" > +error in function application: at (13,64-13,89): reference to undefined function `pf:hash' > +# halted in /data/home/boncz/monet4/src/pathfinder/compiler/semantics/functions.c (check_fun_usage), line 296 > +"pf -A f.xq >/dev/null" > +"pf -A g.xq >/dev/null" > +"pf -A id01.xq >/dev/null" > +"pf -A id04.xq >/dev/null" > +"pf -A or01.xq >/dev/null" > +"pf -A or04.xq >/dev/null" > +"pf -A or10.xq >/dev/null" > "pf -A q01.xq >/dev/null" > "pf -A q02.xq >/dev/null" > "pf -A q03.xq >/dev/null" > @@ -25,6 +35,13 @@ > "pf -A q18.xq >/dev/null" > "pf -A q19.xq >/dev/null" > "pf -A q20.xq >/dev/null" > +"pf -A tst2.xq >/dev/null" > +error in function application: at (1,3-1,22): reference to undefined function `pf:hash' > +# halted in /data/home/boncz/monet4/src/pathfinder/compiler/semantics/functions.c (check_fun_usage), line 296 > +"pf -A tst.xq >/dev/null" > +error in function application: at (1,71-1,92): reference to undefined function `pf:hash' > +# halted in /data/home/boncz/monet4/src/pathfinder/compiler/semantics/functions.c (check_fun_usage), line 296 > +"pf -A t.xq >/dev/null" > "pf -A upd.xq >/dev/null" > > # 16:36:55 > > > Index: pf-A_XMark.stable.out > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/compiler/Tests/pf-A_XMark.stable.out,v > retrieving revision 1.1 > retrieving revision 1.2 > diff -u -d -r1.1 -r1.2 > --- pf-A_XMark.stable.out 28 Dec 2005 17:04:06 -0000 1.1 > +++ pf-A_XMark.stable.out 18 Sep 2007 13:32:26 -0000 1.2 > @@ -5,6 +5,14 @@ > # 16:36:51 > Mtimeout -timeout 60 ./pf-A_XMark pf-A_XMark > # 16:36:51 > > > +"pf -A ff.xq >/dev/null" > +"pf -A f.xq >/dev/null" > +"pf -A g.xq >/dev/null" > +"pf -A id01.xq >/dev/null" > +"pf -A id04.xq >/dev/null" > +"pf -A or01.xq >/dev/null" > +"pf -A or04.xq >/dev/null" > +"pf -A or10.xq >/dev/null" > "pf -A q01.xq >/dev/null" > "pf -A q02.xq >/dev/null" > "pf -A q03.xq >/dev/null" > @@ -25,6 +33,9 @@ > "pf -A q18.xq >/dev/null" > "pf -A q19.xq >/dev/null" > "pf -A q20.xq >/dev/null" > +"pf -A tst2.xq >/dev/null" > +"pf -A tst.xq >/dev/null" > +"pf -A t.xq >/dev/null" > "pf -A upd.xq >/dev/null" > > # 16:36:55 > > > > Index: pf-M_XMark.stable.out > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/compiler/Tests/pf-M_XMark.stable.out,v > retrieving revision 1.6 > retrieving revision 1.7 > diff -u -d -r1.6 -r1.7 > --- pf-M_XMark.stable.out 23 May 2005 22:14:32 -0000 1.6 > +++ pf-M_XMark.stable.out 18 Sep 2007 13:32:26 -0000 1.7 > @@ -5,6 +5,14 @@ > # 16:36:51 > Mtimeout -timeout 60 ./pf-M_XMark pf-M_XMark > # 16:36:51 > > > +"pf -M ff.xq >/dev/null" > +"pf -M f.xq >/dev/null" > +"pf -M g.xq >/dev/null" > +"pf -M id01.xq >/dev/null" > +"pf -M id04.xq >/dev/null" > +"pf -M or01.xq >/dev/null" > +"pf -M or04.xq >/dev/null" > +"pf -M or10.xq >/dev/null" > "pf -M q01.xq >/dev/null" > "pf -M q02.xq >/dev/null" > "pf -M q03.xq >/dev/null" > @@ -25,6 +33,9 @@ > "pf -M q18.xq >/dev/null" > "pf -M q19.xq >/dev/null" > "pf -M q20.xq >/dev/null" > +"pf -M tst2.xq >/dev/null" > +"pf -M tst.xq >/dev/null" > +"pf -M t.xq >/dev/null" > "pf -M upd.xq >/dev/null" > > # 16:36:55 > > > > Index: pf-M_XMark.stable.err > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/compiler/Tests/pf-M_XMark.stable.err,v > retrieving revision 1.6 > retrieving revision 1.7 > diff -u -d -r1.6 -r1.7 > --- pf-M_XMark.stable.err 23 May 2005 22:14:32 -0000 1.6 > +++ pf-M_XMark.stable.err 18 Sep 2007 13:32:26 -0000 1.7 > @@ -5,6 +5,16 @@ > # 16:36:51 > Mtimeout -timeout 60 ./pf-M_XMark pf-M_XMark > # 16:36:51 > > > +"pf -M ff.xq >/dev/null" > +error in function application: at (13,64-13,89): reference to undefined function `pf:hash' > +# halted in /data/home/boncz/monet4/src/pathfinder/compiler/semantics/functions.c (check_fun_usage), line 296 > +"pf -M f.xq >/dev/null" > +"pf -M g.xq >/dev/null" > +"pf -M id01.xq >/dev/null" > +"pf -M id04.xq >/dev/null" > +"pf -M or01.xq >/dev/null" > +"pf -M or04.xq >/dev/null" > +"pf -M or10.xq >/dev/null" > "pf -M q01.xq >/dev/null" > "pf -M q02.xq >/dev/null" > "pf -M q03.xq >/dev/null" > @@ -25,6 +35,13 @@ > "pf -M q18.xq >/dev/null" > "pf -M q19.xq >/dev/null" > "pf -M q20.xq >/dev/null" > +"pf -M tst2.xq >/dev/null" > +error in function application: at (1,3-1,22): reference to undefined function `pf:hash' > +# halted in /data/home/boncz/monet4/src/pathfinder/compiler/semantics/functions.c (check_fun_usage), line 296 > +"pf -M tst.xq >/dev/null" > +error in function application: at (1,71-1,92): reference to undefined function `pf:hash' > +# halted in /data/home/boncz/monet4/src/pathfinder/compiler/semantics/functions.c (check_fun_usage), line 296 > +"pf -M t.xq >/dev/null" > "pf -M upd.xq >/dev/null" > > # 16:36:55 > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > 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] SQL serializer
by Manuel Mayr 18 Sep '07

18 Sep '07

Hi guys, how can i adjust the Makefile.ag to copy the serialize.pl script to the binary-directory. The following approach Makefile.ag>> scripts_pl = { DIR = bindir SOURCES = serialize.pl } doesn't work. Best regards, Manuel -- Manuel Mayr, Dipl. Inf. Institut fuer Informatik, TU Muenchen Tel.: +49 89 289-17259

2 2

[Monetdb-developers] Hi
by Mark Polo 18 Sep '07

18 Sep '07

Hi Im installed MonetDB in windows XP. I dont find the mapi.h.header file.. from where should i get this ? -- View this message in context: http://www.nabble.com/Hi-tf4440370.html#a12669112 Sent from the monetdb-developers mailing list archive at Nabble.com.

4 11

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB/src/testing Mtest.py.in, , 1.307, 1.308
by Sjoerd Mullender 18 Sep '07

18 Sep '07

Please revert and update your clients. The -o option for mclient is gone. Peter Boncz wrote: > Update of /cvsroot/monetdb/MonetDB/src/testing > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv20410 > > Modified Files: > Mtest.py.in > Log Message: > mclient -lx -oxml -fxml > > produces very oddly escaped and pre-abled results (correct/bug?) > in any case, such output is not what the testweb expects > > therefore: removing -fxml > > > > Index: Mtest.py.in > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB/src/testing/Mtest.py.in,v > retrieving revision 1.307 > retrieving revision 1.308 > diff -u -d -r1.307 -r1.308 > --- Mtest.py.in 14 Sep 2007 16:09:12 -0000 1.307 > +++ Mtest.py.in 17 Sep 2007 23:12:34 -0000 1.308 > @@ -2700,7 +2700,7 @@ > dft['MALCLIENT'] = "'mclient -lmal'" > dft['SQLCLIENT'] = "'mclient -lsql'" > dft['SQLDUMP'] = "'msqldump'" > - dft['XQUERYCLIENT'] = "'mclient -lxquery -fxml'" > + dft['XQUERYCLIENT'] = "'mclient -lxquery -oxml'" > dft['X100CLIENT'] = "'x100run_mapi'" > > #par = {} > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- Sjoerd Mullender

1 0

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/benchmarks/MBench/Tests qj01.timeout, , 1.1, 1.2
by Stefan Manegold 17 Sep '07

17 Sep '07

Peter, just for info: This test/query used to run in 20-50 secs (depending on the platform). Now is seems to take at least 104 secs even on our fastest platforms. See also grep -w qj01 /ufs/monet/Testing/Current/pathfinder/.CheckLists/Mtest10..2007.0[89].*.time Stefan On Mon, Sep 17, 2007 at 09:24:23PM +0000, Peter Boncz wrote: > Update of /cvsroot/monetdb/pathfinder/benchmarks/MBench/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv20637 > > Modified Files: > qj01.timeout > Log Message: > > > Index: qj01.timeout > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/benchmarks/MBench/Tests/qj01.timeout,v > retrieving revision 1.1 > retrieving revision 1.2 > diff -u -d -r1.1 -r1.2 > --- qj01.timeout 13 May 2007 09:43:08 -0000 1.1 > +++ qj01.timeout 17 Sep 2007 21:24:20 -0000 1.2 > @@ -1 +1 @@ > -2 > +4 > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > 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] SQL temporary table not working?
by Agustin Schapira 14 Sep '07

14 Sep '07

Hi, I am having problems with SQL TEMPORARY TABLES: even when I insert rows into them, they remain empty. See for example: monetdb-> create local temporary table d (id int); Operation successful monetdb-> insert into d values(1); 1 affected row monetdb-> select * from d; +--------+ | id | +========+ +--------+ 0 rows If I create a TEMPORARY TABLE from a SELECT ... WITH DATA statement, it gets the correct structure but no data. Also, if I later insert rows into the temporary table, it still remains empty. Here's a sample session that demonstrates the problem: monetdb-> create table a (id int); Operation successful monetdb-> insert into a values(1); 1 affected row monetdb-> select * from a; +--------+ | id | +========+ | 1 | +--------+ 1 row monetdb-> create temporary table b as select * from a with data; Operation successful monetdb-> select * from b; +--------+ | id | +========+ +--------+ 0 rows monetdb-> insert into b values(5); 1 affected row monetdb-> select * from b; +--------+ | id | +========+ +--------+ 0 rows monetdb-> insert into b select * from a; 1 affected row monetdb-> select * from b; +--------+ | id | +========+ +--------+ 0 rows This happens with the latest release, compiled yesterday with the -- nightly='stable' switch: # MonetDB Server v5.0.1 # Copyright (c) 1993-2007 CWI, all rights reserved # Compiled for i686-apple-darwin8.10.1/32bit with 32bit OIDs dynamically linked Database: MonetDB 1.18.3 Driver: MonetDB Native Driver 1.6 (Steadfast/MCL-1.0 20070913) auto commit mode: on By the way, this used to work with MonetDB Server v5.0.0_beta1_2 (although the WITH DATA option didn't load the data: I had to create the structure and then INSERT into the table to get the rows). Any ideas? Am I doing something wrong? Are TEMPORARY TABLES not supposed to be used like this? Thanks for your help, -- Agustin

2 1

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB4/src/mapi/Tests manyMapiClients.MIL.py, , 1.2, 1.3
by Fabian Groffen 14 Sep '07

14 Sep '07

On 13-09-2007 23:09:33 +0000, Stefan Manegold wrote: > Update of /cvsroot/monetdb/MonetDB4/src/mapi/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv1511/MonetDB4/src/mapi/Tests > > Modified Files: > manyMapiClients.MIL.py > Log Message: > > clean-up: > do not play any tricks to find where Mapi.py is installed; > rather assume that it is in Python's default search path, > or that `monetdb-clients-config --pythonlibdir` is in PYTHONPATH > +# assume module MonetDB is in Python's default search path, > +# or `monetdb-clients-config --pythonlibdir` is in PYTHONPATH > from MonetDB import Mapi Alternatively, maybe you can do something like try: from MonetDB import Mapi except ImportError: sys.path.insert(0, "autoconf-path-to-mapi") from MonetDB import Mapi ? Of course using the correct python commands for this so it works.

1 0

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/src/sqlhelpers/xmlshred xmlshred.c, , 1.19, 1.20
by Sjoerd Mullender 13 Sep '07

13 Sep '07

Manuel Mayr wrote: > Update of /cvsroot/monetdb/pathfinder/src/sqlhelpers/xmlshred > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv12897/src/sqlhelpers/xmlshred > > Modified Files: > xmlshred.c > Log Message: > > > -- snprintf "bug" > -- fn:number implemented > > > Index: xmlshred.c > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/src/sqlhelpers/xmlshred/xmlshred.c,v > retrieving revision 1.19 > retrieving revision 1.20 > diff -u -d -r1.19 -r1.20 > --- xmlshred.c 13 Sep 2007 11:46:08 -0000 1.19 > +++ xmlshred.c 13 Sep 2007 13:40:21 -0000 1.20 > @@ -281,8 +281,10 @@ > guideout = SHopen_write (guideoutfile); > } > > + > + char outfile[FILENAME_MAX]; > snprintf (status.outfile, FILENAME_MAX, "%s.csv", status.outfile); Shouldn't you chante status.outfile to outfile here? > - shout = SHopen_write (status.outfile); > + shout = SHopen_write (outfile); > } > else > shout = stdout; > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > 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/src/sqlhelpers/xmlshred/include shred_helper.h, , 1.9, 1.10
by Manuel Mayr 13 Sep '07

13 Sep '07

Thanks a lot. Best regards, Manuel Stefan Manegold wrote: > Update of /cvsroot/monetdb/pathfinder/src/sqlhelpers/xmlshred/include > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv32155/src/sqlhelpers/xmlshred/include > > Modified Files: > shred_helper.h > Log Message: > > for the sake of compatibility and portability: > > To ensure that all C files equally benefit from what configure finds out > we need to make pf_config.h the *first* include in each C file > (either explicitly, or implicitly via some other common header file; > since the xmlshredded C files do not seem to share a single common > header file, we go for the explicit solution). > > > Index: shred_helper.h > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/src/sqlhelpers/xmlshred/include/shred_helper.h,v > retrieving revision 1.9 > retrieving revision 1.10 > diff -u -d -r1.9 -r1.10 > --- shred_helper.h 12 Sep 2007 20:07:36 -0000 1.9 > +++ shred_helper.h 12 Sep 2007 20:12:37 -0000 1.10 > @@ -28,7 +28,6 @@ > #ifndef SHRED_HELPER_H__ > #define SHRED_HELPER_H__ > > -#include "pf_config.h" > #include <unistd.h> > #include <stdlib.h> > #include <stdio.h> > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins > > -- Manuel Mayr, Dipl. Inf. Institut fuer Informatik, TU Muenchen Tel.: +49 89 289-17259

1 0