- developers-list - monetdb.org

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/src/sqlhelpers/db2tools common.inc, XQuery_0-20, NONE, 1.1.2.1 load, XQuery_0-20, NONE, 1.1.2.1 table, XQuery_0-20, NONE, 1.1.2.1
by Stefan Manegold 24 Sep '07

24 Sep '07

To ensure a smooth finalization of our combined effort to get the upcoming release out "as fast as possible" and without any self-made hurdles, I assume that adding these new "feature(s)" in the *release branch* has been coordinated with Sjoerd, right? (In particular wrt. how/where they need to be added to the source and in particular binary packages, documentation, and which platforms they are targeted for (Windows??).) Greetings from Vienna, Stefan On Mon, Sep 24, 2007 at 09:10:33AM +0000, Manuel Mayr wrote: > Update of /cvsroot/monetdb/pathfinder/src/sqlhelpers/db2tools > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv18874 > > Added Files: > Tag: XQuery_0-20 > common.inc load table > Log Message: > > > Shell scripts to create tables, and load content for SQL-backend > > > --- NEW FILE: load --- > #!/bin/sh > > THIS=${0} > THISDIR=${0%/*} > THISFILE=${0##*/} > DB2=`which db2` > > source common.inc > > ################################################ > # FUNCTIONS > > function load_table { > #check parameter list > if [ ${#} -ne 3 ]; then > error "Usage: ${0} <file> <schema> <table>" > fi > > SCHEMA=${2} > FILE=${1} > TABLE=${3} > > # set schema to ours > ${DB2} "set current schema ${SCHEMA}" > > # create the names-table > ${DB2} -t<<EOT > LOAD FROM ${FILE} OF DEL > MODIFIED BY DELPRIORITYCHAR > REPLACE INTO ${TABLE} > NONRECOVERABLE > INDEXING MODE rebuild; > EOT > > ${DB2} "SET INTEGRITY FOR ${TABLE} IMMEDIATE CHECKED" > EFLAG=${?} > return ${EFLAG} > } > > function print_help () { > out "Pathfinder XQuery" > out "(c) Database Group, Technische Universitaet Muenchen" > out "" > out "Usage: ${THISFILE} (create|drop) <db> <schema> <file>" > out "" > out -e "\t<db>:\t\tName of the Database the content should be placed/removed." > out -e "\t<schema>:\tName of the Schema the content should be placed/removed." > out -e "\t<names_file>:\tNames file" > out -e "\t<file>:\tEncoded document" > } > > ################################################ > # MAIN > > if [ $# -ne 4 ]; then > print_help; > exit 0; > fi > > DATABASE=${1} > SCHEMA=${2} > NFILE=${3} > LFILE=${4} > > ${DB2} "connect to ${DATABASE}" > > EFLAG=${?} > out -ne "Connecting to database ${DATABASE} ... "; fail $EFLAG; > > test ${EFLAG} -ne 0 && exit 1; > > load_table "${NFILE}" "${SCHEMA}" "${TAB_NAMES}"; > EFLAG=${?}; > out -ne "Loading ${SCHEMA}.${TAB_NAMES} ... "; fail ${EFLAG}; > > load_table ${LFILE} "${SCHEMA}" "${TAB_DOC}"; > EFLAG=${?}; > out -ne "Loading ${SCHEMA}.${TAB_DOC} ... "; fail ${EFLAG}; > > ${DB2} "terminate" > > --- NEW FILE: table --- > #!/bin/sh > > THIS=${0} > THISDIR=${0%/*} > THISFILE=${0##*/} > DB2=`which db2` > > source common.inc > > ################################################ > # FUNCTIONS > > function create_names { > #check parameter list > if [ ${#} -ne 2 ]; then > error "Usage: ${0} <schema> <tabname>" > fi > > SCHEMA=${1} > TABNAME=${2} > > # set schema to ours > ${DB2} "set current schema ${SCHEMA}" > > # create the names-table > ${DB2} -t<<EOT > CREATE TABLE ${TABNAME}(nameid INT NOT NULL PRIMARY KEY, > name VARCHAR(32) NOT NULL); > EOT > EFLAG=${?} > return ${EFLAG} > } > > function create_doc { > #check parameter list > if [ ${#} -ne 3 ]; then > error "Usage: ${0} <schema> <tabname> <namesname>" > fi > > SCHEMA=${1} > TABNAME=${2} > NAMESNAME=${3} > > ${DB2} "set current schema ${SCHEMA}" > > ${DB2} -t<<EOT > CREATE TABLE ${TABNAME}(pre INT NOT NULL PRIMARY KEY, > size INT NOT NULL, > level SMALLINT NOT NULL, > kind SMALLINT, > nameid INT, > value VARCHAR(100), > guide INT NOT NULL, > FOREIGN KEY (nameid) references ${NAMESNAME}(nameid)); > EOT > EFLAG=${?} > return ${EFLAG} > } > > function create_xmldoc { > #check parameter list > if [ ${#} -ne 4 ]; then > error "Usage: ${0} <schema> <tabname> <docname> <namesname>" > fi > > SCHEMA=${1} > TABNAME=${2} > DOCNAME=${3} > NAMENAME=${4} > > ${DB2} "set current schema ${SCHEMA}" > > ${DB2} -t<<EOT > CREATE VIEW ${TABNAME}(pre, size, level, kind, guide, > nameid, value, name) AS > (SELECT pre, size, level, kind, guide, > doc.nameid, value, name > FROM ${DOCNAME} AS doc > LEFT OUTER JOIN > ${NAMESNAME} AS names > ON doc.nameid = names.nameid); > EOT > EFLAG=${?} > return ${EFLAG} > } > > function drop_table { > #check parameter list > if [ ${#} -ne 1 ]; then > error "Usage: ${0} <table>" > fi > > TABLE=${1} > > ${DB2} "drop table ${TABLE}" > } > > function drop_names { > #check parameter list > if [ ${#} -ne 1 ]; then > error "Usage: ${0} <schema>" > fi > > SCHEMA=${1} > > ${DB2} "set current schema ${SCHEMA}" > drop_table "${TAB_NAMES}" > EFLAG=${?} > return ${EFLAG} > } > > function drop_doc { > #check parameter list > if [ ${#} -ne 1 ]; then > error "Usage: ${0} <schema>" > fi > > SCHEMA=${1} > > ${DB2} "set current schema ${SCHEMA}" > drop_table "${TAB_DOC}" > EFLAG=${?} > return ${EFLAG} > } > > function drop_xmldoc { > #check parameter list > if [ ${#} -ne 1 ]; then > error "Usage: ${0} <schema>" > fi > > SCHEMA=${1} > > ${DB2} "set current schema ${SCHEMA}" > ${DB2} "drop view xmldoc" > EFLAG=${?} > return ${EFLAG} > } > > function print_help () { > out "Pathfinder XQuery" > out "(c) Database Group, Technische Universitaet Muenchen" > out "" > out "Usage: $THISFILE (create|drop) <db> <schema>" > out "" > out -e "\t(create|drop):\teither create or drop the tables " > out -e "\t<db>:\t\tName of the Database the tables should be placed/removed." > out -e "\t<schema>:\tName of the Schema the tables should be placed/removed." > } > > ################################################ > # MAIN > > if [ $# -ne 3 ]; then > print_help; > exit 0; > fi > > OPTION=${1} > DATABASE=${2} > SCHEMA=${3} > > ${DB2} "connect to ${DATABASE}" > EFLAG=$? > out -ne "Connecting to database ${DATABASE} ... "; fail $EFLAG; > test $EFLAG -ne 0 && exit 1; > > case ${OPTION} in > create) create_names ${SCHEMA} ${TAB_NAMES}; > EFLAG=${?}; > out -ne "Creating ${SCHEMA}.${TAB_NAMES} ... "; fail ${EFLAG}; > > create_doc ${SCHEMA} ${TAB_DOC} ${TAB_NAMES}; > EFLAG=${?}; > out -ne "Creating ${SCHEMA}.${TAB_DOC} ... "; fail ${EFLAG}; > > create_xmldoc ${SCHEMA} ${TAB_XMLDOC} ${TAB_DOC} ${TAB_NAMES}; > EFLAG=${?}; > out -ne "Creating ${SCHEMA}.${TAB_XMLDOC} ... "; fail ${EFLAG}; > ;; > > drop) drop_xmldoc ${SCHEMA} > EFLAG=${?} > out -ne "Dropping ${SCHEMA}.${TAB_XMLDOC} ... "; fail ${EFLAG}; > > drop_doc ${SCHEMA} > EFLAG=${?} > out -ne "Dropping ${SCHEMA}.${TAB_DOC} ... "; fail ${EFLAG}; > > drop_names ${SCHEMA} > EFLAG=${?} > out -ne "Dropping ${SCHEMA}.${TAB_NAMES} ... "; fail ${EFLAG}; > ;; > *) print_help; > exit 1; > ;; > esac > ${DB2} "terminate" > > --- NEW FILE: common.inc --- > DEBUG=0 > > TAB_NAMES="names" > TAB_DOC="doc" > TAB_XMLDOC="xmldoc" > > DB2=`which db2` > > function fail { > if [ ${#} -ne 1 ]; then > error "Wrong use of fail" > fi > > if [ ${1} -eq 0 ]; then > out "Success" > return 0; > else > out "Failed" > return 0; > fi > } > > function error { > if [ ${#} -ne 1 ]; then > echo "Wrong use of error" > exit 1; > fi > echo -e "Error: ${1}" > exit 1 > } > > function warning > { > if [ ${#} -ne 1 ]; then > error "Wrong use of debug" > fi > echo -e "Warning: ${1}" > } > > function out { > if [ ${#} -eq 1 ]; then > echo -e "${1}" > return 0; > fi > if [ ${#} -eq 2 ]; then > echo "${1}" "${2}" > else > error "wrong use of out" > fi > } > > function debug { > if [ ${#} -ne 1 ]; then > error "Wrong use of debug" > fi > test ${DEBUG} -eq 1 && echo -e "Debug: ${1}" > } > > function LOG1 { > prompt="\n# `date +%H:%M:%S` > "; { echo -en "$prompt$prompt" ; echo -n "$*" ; echo -en "$prompt\n\n" ; } >&2; > } > > function getAbsolutePath { > if [ -z ${1} ]; then > error "Wrong use of ${0}"; > fi > > PATH_=${1%/*} > FILE_=${1##*/} > > echo `cd ${PATH_} 2> /dev/null && pwd || echo ${PATH_}`/${FILE_} > } > > test -z $DB2 && error "DB2 not available"; > > > ------------------------------------------------------------------------- > 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 |

4 3

[Monetdb-developers] hi
by Mark Polo 20 Sep '07

20 Sep '07

hi, Monet DB is in-memory database only ? is it disk-based just like timesten contains both? thnaks n regards mark polo -- View this message in context: http://www.nabble.com/hi-tf4486230.html#a12793347 Sent from the monetdb-developers mailing list archive at Nabble.com.

2 1

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/compiler/sql lalg2sql.brg, , 1.73, 1.74
by Stefan Manegold 19 Sep '07

19 Sep '07

On Wed, Sep 19, 2007 at 07:19:52AM +0000, Manuel Mayr wrote: > Update of /cvsroot/monetdb/pathfinder/compiler/sql > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv17096/sql > > Modified Files: > lalg2sql.brg > Log Message: > > > Fixing failure indicated by testweb Thanks! BUT: http://sourceforge.net/mailarchive/forum.php?thread_name=20070918223806.GA2… says: " [...] IMPORTANT NOTES: 1) As usually, as of NOW, a) ALL bug fixes (and ONLY those) MUST be checked in to the above release branches (and ONLY there)! b) ALL new features (and ONLY those) MUST be checked in to the development trunk (HEAD) (and ONLY there)! (In case you need assistance please feel free to contact MonetDB-developers@li... .) [...] " Stefan > Index: lalg2sql.brg > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/compiler/sql/lalg2sql.brg,v > retrieving revision 1.73 > retrieving revision 1.74 > diff -u -d -r1.73 -r1.74 > --- lalg2sql.brg 18 Sep 2007 11:47:20 -0000 1.73 > +++ lalg2sql.brg 19 Sep 2007 07:19:48 -0000 1.74 > @@ -482,8 +482,6 @@ > #define EXT_COLUMN_NAME(alias,att,ty) (ext_column_name ( \ > (alias), new_col ((att),(ty)))) > > - > - > /* .......... Column Environment Helper Functions .......... */ > > struct sql_column_env_t > @@ -1523,14 +1521,18 @@ > * twigs */ > PFla_op_t *twig; > unsigned int i; > - for (i = 0; i < PFarray_last (frags); i++) { > - twig = *(PFla_op_t **)PFarray_at (frags, i); > - if (twig == p) > - break; > - } > - if (i < PFarray_last (frags) && twig) { > - SER_REPORT(p) = ser_tc; > - return; > + > + if (p->kind == la_twig) { > + for (i = 0; i < PFarray_last (frags); i++) { > + twig = *(PFla_op_t **)PFarray_at (frags, i); > + if (twig == p) > + break; > + } > + > + if (i < PFarray_last (frags) && twig) { > + SER_REPORT(p) = ser_tc; > + return; > + } > } > > /* if we find a leaf return yes */ > @@ -1773,10 +1775,8 @@ > alias_bind(document, alias (docalias1))), > eq (PRE(docalias1), item_pre)), > alias_bind (document, alias (docalias2))), > - and_ ( > - gteq (PRE(docalias2), PRE(docalias1)), > - gteq (add (PRE(docalias1), SIZE(docalias1)), > - PRE(docalias2))))), > + between (PRE(docalias2), PRE(docalias1), > + add (PRE(docalias1), SIZE(docalias1))))), > NULL, > (IS_LITERAL(cpos))? > stmt_list (PRE(docalias2)): > @@ -2211,12 +2211,14 @@ > case 6: > /* Rel: thetajoin (Rel, Rel) */ > case 8: > + { > assert (kids[0] && nts[0]); > assert (kids[1] && nts[1]); > /* reduce the first child */ > reduce (kids[0], nts[0]); > > PFarray_t *left_args = PFarray (sizeof(PFsql_t*)); > + /* left join predicate for the equijoin */ > if (p->kind == la_eqjoin) { > PFalg_simple_type_t l_ty; > > @@ -2229,7 +2231,7 @@ > p->sem.eqjoin.att1, > l_ty); > } > - /* join predicates for the theta-join operator */ > + /* left join predicates for the theta-join operator */ > else if (p->kind == la_thetajoin) { > PFalg_att_t left; > PFalg_simple_type_t l_ty; > @@ -2256,6 +2258,7 @@ > reduce (kids[1], nts[1]); > > PFarray_t *right_args = PFarray (sizeof(PFsql_t*)); > + /* left join predicate for the equi-join operator */ > if (p->kind == la_eqjoin) { > PFalg_simple_type_t r_ty; > > @@ -2382,7 +2385,7 @@ > where_list_add (WHERELIST(p), cond); > } > } > - break; > + } break; > > /* Rel: semijoin (Rel, Rel) */ > case 7: > > > ------------------------------------------------------------------------- > 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] Release preparations: Please refrain from checkins!
by Stefan Manegold 19 Sep '07

19 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 18 Sep '07

18 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