October 2007 - developers-list

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/compiler/Tests All, , NONE, 1.1 mal01.mal, , NONE, 1.1 mal01.stable.err, , NONE, 1.1 mal01.stable.out, , NONE, 1.1 sql01.mal, , NONE, 1.1 sql01.stable.err, , NONE, 1.1 sql01.stable.out, , NONE, 1.1
by Stefan Manegold 09 Oct '07

09 Oct '07

On Sun, Oct 07, 2007 at 06:44:57AM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/compiler/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv1743/Tests > > Added Files: > All mal01.mal mal01.stable.err mal01.stable.out sql01.mal > sql01.stable.err sql01.stable.out > Log Message: > Patching some very old code to bring it closer to reality. > The examples roughly indicate the code to be considered for inclusion > in a compiled plan. The expected gain is only 25-50% interpreter overhead, > which result from known argument locations and stack initialization actions. > A real optimizing MAL ->C compiler should weave instructions to > more efficient ones, e.g. dropping intermediates. > > The SQL version highlights, however, the calls needed against the BBP > due to the shared bat assumption. > > [...] > --- NEW FILE: sql01.mal --- > include sql; ^^^ This test is bound to fail here (i.e., in MonetDB5) as there is no module "sql" in MonetDB5; module "sql" is only provided by sql. Stefan > #sql.compiler("sql01","select * from tables;"); > include mal_compiler; > function user.qry():void; > T1:bat[:oid,:int]{notnil=true,rows=0:lng,bid=113} := sql.bind("tmp","Ttables","id",0); > constraints.emptySet(T1); > T10:bat[:oid,:sht]{notnil=true,rows=0:lng,bid=117} := sql.bind("tmp","Ttables","type",0); > T13:bat[:oid,:int]{notnil=true,rows=30:lng,bid=67} := sql.bind("sys","Ttables","id",0); > T15:bat[:oid,:int]{notnil=true,rows=0:lng,bid=307} := sql.bind("sys","Ttables","id",1); > constraints.emptySet(T15); > T15:bat[:oid,:int]{notnil=true,rows=0:lng,bid=307} := nil; > T16:bat[:oid,:int]{notnil=true,rows=0:lng,bid=309} := sql.bind("sys","Ttables","id",2); > constraints.emptySet(T16); > T16:bat[:oid,:int]{notnil=true,rows=0:lng,bid=309} := nil; > T20:bat[:oid,:sht]{notnil=true,rows=30:lng,bid=71} := sql.bind("sys","Ttables","type",0); > T39:bat[:oid,:str]{notnil=true,rows=0:lng,bid=114} := sql.bind("tmp","Ttables","name",0); > T42:bat[:oid,:str]{notnil=true,rows=30:lng,bid=68} := sql.bind("sys","Ttables","name",0); > T47:bat[:oid,:int]{notnil=true,rows=0:lng,bid=115} := sql.bind("tmp","Ttables","schemaTid",0); > T50:bat[:oid,:int]{notnil=true,rows=30:lng,bid=69} := sql.bind("sys","Ttables","schemaTid",0); > T55:bat[:oid,:str]{notnil=true,rows=0:lng,bid=116} := sql.bind("tmp","Ttables","query",0); > T58:bat[:oid,:str]{notnil=true,rows=30:lng,bid=70} := sql.bind("sys","Ttables","query",0); > T64:bat[:oid,:bit]{notnil=true,rows=0:lng,bid=118} := sql.bind("tmp","Ttables","system",0); > T67:bat[:oid,:bit]{notnil=true,rows=30:lng,bid=72} := sql.bind("sys","Ttables","system",0); > T72:bat[:oid,:sht]{notnil=true,rows=0:lng,bid=119} := sql.bind("tmp","Ttables","commitTaction",0); > T75:bat[:oid,:sht]{notnil=true,rows=30:lng,bid=73} := sql.bind("sys","Ttables","commitTaction",0); > T8{rows=0:lng} := algebra.markT(T1,0@0); > T9{rows=0:lng} := bat.reverse(T8); > T8{rows=0:lng} := nil; > T12{rows=0:lng} := algebra.join(T9,T10); > T10:bat[:oid,:sht]{notnil=true,rows=0:lng,bid=117} := nil; > T18{rows=30:lng} := algebra.markT(T13,0@0); > T19{rows=30:lng} := bat.reverse(T18); > T18{rows=30:lng} := nil; > T21{rows=30:lng} := algebra.join(T19,T20); > T20:bat[:oid,:sht]{notnil=true,rows=30:lng,bid=71} := nil; > T22{rows=31:lng} := bat.setWriteMode(T21); > T21{rows=30:lng} := nil; > bat.append(T22,T12,true); > T12{rows=0:lng} := nil; > T26{rows=31:lng} := algebra.uselect(T22,nil:sht,2:sht,false,false); > T29{rows=31:lng} := algebra.markT(T26,0@0); > T26{rows=31:lng} := nil; > T30{rows=31:lng} := bat.reverse(T29); > T29{rows=31:lng} := nil; > T31{rows=0:lng} := algebra.join(T9,T1); > T1:bat[:oid,:int]{notnil=true,rows=0:lng,bid=113} := nil; > T32{rows=30:lng} := algebra.join(T19,T13); > T13:bat[:oid,:int]{notnil=true,rows=30:lng,bid=67} := nil; > T33{rows=31:lng} := bat.setWriteMode(T32); > T32{rows=30:lng} := nil; > bat.append(T33,T31,true); > T31{rows=0:lng} := nil; > T35{rows=31:lng} := algebra.join(T30,T33); > T36{rows=31:lng} := algebra.markT(T35,0@0); > T35{rows=31:lng} := nil; > T37{rows=31:lng} := bat.reverse(T36); > T36{rows=31:lng} := nil; > T38{rows=31:lng} := algebra.joinPath(T37,T30,T33); > T33{rows=31:lng} := nil; > T41{rows=0:lng} := algebra.join(T9,T39); > T39:bat[:oid,:str]{notnil=true,rows=0:lng,bid=114} := nil; > T43{rows=30:lng} := algebra.join(T19,T42); > T42:bat[:oid,:str]{notnil=true,rows=30:lng,bid=68} := nil; > T44{rows=31:lng} := bat.setWriteMode(T43); > T43{rows=30:lng} := nil; > bat.append(T44,T41,true); > T41{rows=0:lng} := nil; > T46{rows=31:lng} := algebra.joinPath(T37,T30,T44); > T44{rows=31:lng} := nil; > T49{rows=0:lng} := algebra.join(T9,T47); > T47:bat[:oid,:int]{notnil=true,rows=0:lng,bid=115} := nil; > T51{rows=30:lng} := algebra.join(T19,T50); > T50:bat[:oid,:int]{notnil=true,rows=30:lng,bid=69} := nil; > T52{rows=31:lng} := bat.setWriteMode(T51); > T51{rows=30:lng} := nil; > bat.append(T52,T49,true); > T49{rows=0:lng} := nil; > T54{rows=31:lng} := algebra.joinPath(T37,T30,T52); > T52{rows=31:lng} := nil; > T57{rows=0:lng} := algebra.join(T9,T55); > T55:bat[:oid,:str]{notnil=true,rows=0:lng,bid=116} := nil; > T59{rows=30:lng} := algebra.join(T19,T58); > T58:bat[:oid,:str]{notnil=true,rows=30:lng,bid=70} := nil; > T60{rows=31:lng} := bat.setWriteMode(T59); > T59{rows=30:lng} := nil; > bat.append(T60,T57,true); > T57{rows=0:lng} := nil; > T62{rows=31:lng} := algebra.joinPath(T37,T30,T60); > T60{rows=31:lng} := nil; > T63{rows=31:lng} := algebra.joinPath(T37,T30,T22); > T22{rows=31:lng} := nil; > T66{rows=0:lng} := algebra.join(T9,T64); > T64:bat[:oid,:bit]{notnil=true,rows=0:lng,bid=118} := nil; > T68{rows=30:lng} := algebra.join(T19,T67); > T67:bat[:oid,:bit]{notnil=true,rows=30:lng,bid=72} := nil; > T69{rows=31:lng} := bat.setWriteMode(T68); > T68{rows=30:lng} := nil; > bat.append(T69,T66,true); > T66{rows=0:lng} := nil; > T71{rows=31:lng} := algebra.joinPath(T37,T30,T69); > T69{rows=31:lng} := nil; > T74{rows=0:lng} := algebra.join(T9,T72); > T72:bat[:oid,:sht]{notnil=true,rows=0:lng,bid=119} := nil; > T76{rows=30:lng} := algebra.join(T19,T75); > T75:bat[:oid,:sht]{notnil=true,rows=30:lng,bid=73} := nil; > T77{rows=31:lng} := bat.setWriteMode(T76); > T76{rows=30:lng} := nil; > bat.append(T77,T74,true); > T74{rows=0:lng} := nil; > T79{rows=31:lng} := algebra.joinPath(T37,T30,T77); > T77{rows=31:lng} := nil; > T81{rows=0:lng} := algebra.project(T9,1); > T9{rows=0:lng} := nil; > T83{rows=30:lng} := algebra.project(T19,0); > T19{rows=30:lng} := nil; > T84{rows=31:lng} := bat.setWriteMode(T83); > T83{rows=30:lng} := nil; > bat.append(T84,T81,true); > T81{rows=0:lng} := nil; > T86{rows=31:lng} := algebra.joinPath(T37,T30,T84); > T37{rows=31:lng} := nil; > T30{rows=31:lng} := nil; > T84{rows=31:lng} := nil; > T87 := sql.resultSet(8,1,T38); > sql.rsColumn(T87,"sys.tables","id","int",32,0,T38); > T38{rows=31:lng} := nil; > sql.rsColumn(T87,"sys.tables","name","varchar",1024,0,T46); > T46{rows=31:lng} := nil; > sql.rsColumn(T87,"sys.tables","schemaTid","int",32,0,T54); > T54{rows=31:lng} := nil; > sql.rsColumn(T87,"sys.tables","query","varchar",2048,0,T62); > T62{rows=31:lng} := nil; > sql.rsColumn(T87,"sys.tables","type","smallint",16,0,T63); > T63{rows=31:lng} := nil; > sql.rsColumn(T87,"sys.tables","system","boolean",1,0,T71); > T71{rows=31:lng} := nil; > sql.rsColumn(T87,"sys.tables","commitTaction","smallint",16,0,T79); > T79{rows=31:lng} := nil; > sql.rsColumn(T87,"sys.tables","temporary","tinyint",8,0,T86); > T86{rows=31:lng} := nil; > sql.exportResult(T87,""); > end qry; > compiler.MALtoC("user","qry","sql01"); -- | 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] BAT sizes
by Stefan Manegold 07 Oct '07

07 Oct '07

[felt free to cc the monetdb-developers list as more people might be interested or want to contribute] Henning, are you just "concerned" or are you having concrete problems with the bat sizes? In cany case, to give any reasonable answer we'd need to know more about the details. In particular how large is the BAT your talking about. I.e., with "b" being your BAT and "c := b.copy()", please check & report b.count(); b.info().reverse().like("batBuns").like("size").print(); b.batsize(); b.batdsksize(); c.count(); c.info().reverse().like("batBuns").like("size").print(); c.batsize(); c.batdsksize(); Stefan On Fri, Oct 05, 2007 at 01:47:01PM +0200, Henning Rode wrote: > hej stefan, > > thanks for the answer. so in conclusion, the over-allocation of memory > is quite normal, and nothing to worry about. > > i was more surprised that the copied BAT still has this considerable > over-allocation of memory, though it exactly knows how many entries it > needs to hold. > > groeten -henning -- | 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 1

Re: [Monetdb-developers] [Monetdb-bugs] JDBC: Negative Integer in Prepared Statement
by Stefan Manegold 06 Oct '07

06 Oct '07

Hi Jan, thanks for using MonetDB, and sorry for the inconvenience. We'll investigate the reported problem shortly. However, the monetdb-bugs mailing list is actually not meant to be used directly (admittedly our fault, in case we didn't communicate this clearly and/or haven't prevented direct postings, yet). The monetdb-bugs mailing list is mainly meant notify developers of newly files bug reports and their follow-up comments. Hence, could you please file your bug using the SF bug tracker at http://sourceforge.net/tracker/?atid=482468&group_id=56967&func=browse ? Thanks, Stefan On Sat, Oct 06, 2007 at 08:08:57PM +0200, Schaffner, Jan wrote: > Hi, > > When using prepared statements in Java, I am unable to pass negative > integer values to the database: > > String APPEND_JOURNAL = "INSERT INTO journal VALUES (?, ?);"; > st = con.prepareStatement(APPEND_JOURNAL); > st.setInt(1, fromAcc); > st.setInt(2, -amount); > st.executeUpdate(); > > The table "journal" has two columns: account (int) and amount (bigint). > > The insert statement executes without error, but inserts the positive > value (+amount, cf. line 4). The debugger, in contrast, says something > like "exec 3(200, -30)". Note that is has a minus in front of the > second parameter. > > Without prepared statements, however, inserting negative values works > perfactly fine. > > Thanks, > Jan -- | 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-pf-checkins] pathfinder/tests/BugTracker/Tests noroot.SF-1452237.XQUERY.bat, XQuery_0-20, NONE, 1.1.2.1
by Sjoerd Mullender 05 Oct '07

05 Oct '07

Stefan Manegold wrote: > Update of /cvsroot/monetdb/pathfinder/tests/BugTracker/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv23002 > > Added Files: > Tag: XQuery_0-20 > noroot.SF-1452237.XQUERY.bat > Log Message: > > added Windows version --- still needs to be tested/checked! > > > --- NEW FILE: noroot.SF-1452237.XQUERY.bat --- > @XQUERY_CLIENT@ -s1 -f xml-noroot %...% -- Sjoerd Mullender

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB4/tests/BugDay_2005-10-06_4.8/Tests multiple_servers.SF-914113.MIL.bat, MonetDB_4-20, NONE, 1.1.2.1
by Sjoerd Mullender 05 Oct '07

05 Oct '07

Stefan Manegold wrote: > Update of /cvsroot/monetdb/MonetDB4/tests/BugDay_2005-10-06_4.8/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv15739/MonetDB4/tests/BugDay_2005-10-06_4.8/Tests > > Added Files: > Tag: MonetDB_4-20 > multiple_servers.SF-914113.MIL.bat > Log Message: > > added Windows version --- still needs to be tested/checked! > > > --- NEW FILE: multiple_servers.SF-914113.MIL.bat --- > @call @MSERVER@ --dbname=@TSTDB@ I can tell you right away that this won't fly. Either it has to be a .in file so that the @...@ stuff gets expanded, or if they are supposed to be environment variables, they should be %...%. -- Sjoerd Mullender

1 0

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/modules/pftijah nexi_generate_mil.c, XQuery_0-18, 1.33.2.3, 1.33.2.4
by Sjoerd Mullender 05 Oct '07

05 Oct '07

Djoerd Hiemstra wrote: > Update of /cvsroot/monetdb/pathfinder/modules/pftijah > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv1427 > > Modified Files: > Tag: XQuery_0-18 > nexi_generate_mil.c > Log Message: > The ir-model="LM" option was translated to "LMs" in the algebra. You do realize that the XQuery_0-18 branch is the *old* stable branch and that we're now using XQuery_0-20? > > Index: nexi_generate_mil.c > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/modules/pftijah/nexi_generate_mil.c,v > retrieving revision 1.33.2.3 > retrieving revision 1.33.2.4 > diff -u -d -r1.33.2.3 -r1.33.2.4 > --- nexi_generate_mil.c 15 Jun 2007 08:53:00 -0000 1.33.2.3 > +++ nexi_generate_mil.c 4 Oct 2007 13:11:35 -0000 1.33.2.4 > @@ -711,7 +711,7 @@ > case MODEL_LM : > > // MILPRINTF(MILOUT, "R%d := R%d.p_containing_q_LM(terms, qenv);\n", com_num, com_nr_left); > - MILPRINTF(MILOUT, "R%d := R%d.p_containing_q_LMs%s(terms%s,qenv);\n", com_num, com_nr_left, parserCtx->ffPfx, parserCtx->flastPfx); > + MILPRINTF(MILOUT, "R%d := R%d.p_containing_q_LM%s(terms%s,qenv);\n", com_num, com_nr_left, parserCtx->ffPfx, parserCtx->flastPfx); > > break; > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. > Still grepping through log files to find problems? Stop. > Now Search log events and configuration files using AJAX and a browser. > Download your FREE copy of Splunk now >> http://get.splunk.com/ > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins -- Sjoerd Mullender

5 5

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/tests/gdkTests/Tests casts.mal, MonetDB_5-0, 1.4, 1.4.4.1
by Stefan Manegold 02 Oct '07

02 Oct '07

On Sat, Sep 29, 2007 at 09:07:39PM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/tests/gdkTests/Tests > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv20428/Tests > > Modified Files: > Tag: MonetDB_5-0 > casts.mal > Log Message: > Better handle to detect the differences. > No need to roll forward. Since this checkin was to the abondoned MonetDB_5-0 branch, there will not even be any attempts to propagate it. For info: Since Sep 18 2007, we have and use release branch MonetDB_5-2 for MonetDB5; see also http://sourceforge.net/mailarchive/forum.php?thread_name=20070918223806.GA2… 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 0

[Monetdb-developers] Mserver is aborting
by Riham Abdel Kader 02 Oct '07

02 Oct '07

Forgot the attachments! --------------------------------------------------------------------------- Hi all, I checked out today the MonetDB/XQuery code and Mserver is crashing whenever I try to execute MIL statements using the mclient command. More details follow. I first compile an XQuery to MIL statements using the command "pf -A" Then I execute the MIL statements with "mclient -t -l" Whenever I do so, I get the correct results but Mserver aborts after giving the following error message: Mserver: monet_tbl.mx:1743: TBL_M_decref: Assertion `p' failed. Aborted I have attached the XQuery file and the generated MIL file. Thank you and best regards, Riham -- Address: Database Group, Dept of EEMCS, University of Twente, POBox 217, 7500 AE Enschede, The Netherlands Phone: +31 (0)53 489 4628 Fax: +31 (0)53 489 2927 Email: r.abdelkader(a)ewi.utwente.nl for $p in doc("doc_100000_10ab_1000pr.xml")//a/p, $r in doc("doc_100000_10ab_1000pr.xml")//b/r where $p/text() = $r/text() return $r module ("pathfinder"); module ("mkey"); var time_load; var time_query; var time_print; var a0000; var a0001; var a0002; var a0003; var a0004; var a0005; var a0006; var a0007; var a0008; var a0009; var a0010; var a0011; var a0012; var a0013; var a0014; var unused; var ws; unused := nil; # trace structure var trace_outer; var trace_inner; var trace_iter; var trace_msg; var trace_item; var trace_type; var trace_rel; # Begin rule: "Query: serialize(FragList, Rel)" a0001 := CATCH ({ ws := ws_create (); # Begin rule: "Rel: lit_tbl" # a0000: iter(nat) a0000 := new (void, oid).seqbase (0@0); a0000.append (1@0); a0000.access (BAT_READ); # a0001: item(str) a0001 := new (void, str).seqbase (0@0); a0001.append ("doc_100000_10ab_1000pr.xml"); a0001.access (BAT_READ); # End rule: "Rel: lit_tbl" # Begin rule: "FragRel: doc_tbl(Rel)" # a0000: iter(nat) # a0005: item(pre) # a0004: item(pfrag) a0003 := doc_tbl (ws, a0001); a0005 := a0003.fetch (1); a0004 := a0003.fetch (2); ws := a0003.fetch (0); a0003 := unused; a0002 := unused; a0001 := unused; # End rule: "FragRel: doc_tbl(Rel)" # Begin rule: "Rel: roots(FragRel)" # a0000: iter(nat) # a0005: item(pre) # a0004: item(pfrag) # End rule: "Rel: roots(FragRel)" # Begin rule: "Frag: fragment(FragRel)" # End rule: "Frag: fragment(FragRel)" # Begin rule: "FragList: empty_frag" # End rule: "FragList: empty_frag" # Begin rule: "FragList: frag_union(FragList, Frag)" # End rule: "FragList: frag_union(FragList, Frag)" # Begin rule: "Rel: llscj_desc(FragList, Rel)" a0001 := loop_lifted_descendant_step_with_nsloc_test (a0000, a0005, a0004, ws, 2, "", "b"); a0002 := a0001.fetch (1); a0003 := a0001.fetch (2).materialize (a0002); # a0002: item(pre) # a0003: item(pfrag) a0006 := a0001.fetch (0).materialize (a0001.fetch (1)); # a0006: iter(nat) a0001 := unused; # End rule: "Rel: llscj_desc(FragList, Rel)" # Begin rule: "Rel: llscj_child(FragList, Rel)" a0001 := loop_lifted_child_step_with_nsloc_test (a0006, a0002, a0003, ws, 3, "", "r"); a0007 := a0001.fetch (1); a0008 := a0001.fetch (2).materialize (a0007); # a0007: item(pre) # a0008: item(pfrag) # a0009: iter(nat) a0001 := unused; a0002 := unused; a0003 := unused; a0006 := unused; # End rule: "Rel: llscj_child(FragList, Rel)" # Begin rule: "Rel: project(Rel)" # a0008: item(pfrag) # a0007: item(pre) a0009 := unused; # End rule: "Rel: project(Rel)" # Begin rule: "Rel: number(Rel)" # a0008: item(pfrag) # a0007: item(pre) a0001 := a0007.mark (1@0); # a0001: iter1(nat) # End rule: "Rel: number(Rel)" # Begin rule: "Rel: project(Rel)" # a0008: item(pfrag) # a0007: item(pre) # a0001: iter(nat) # End rule: "Rel: project(Rel)" # Begin rule: "Rel: llscj_child(FragList, Rel)" a0002 := loop_lifted_child_step_with_kind_test (a0001, a0007, a0008, ws, 3, TEXT); a0003 := a0002.fetch (1); a0006 := a0002.fetch (2); # a0003: item(pre) # a0006: item(pfrag) a0009 := a0002.fetch (0).materialize (a0002.fetch (1)); # a0009: iter(nat) a0002 := unused; # End rule: "Rel: llscj_child(FragList, Rel)" # Begin rule: "Rel: doc_access(FragList, Rel)" # a0003: item(pre) # a0006: item(pfrag) # a0009: iter(nat) a0002 := mposjoin (mposjoin (a0003, a0006, ws.fetch (PRE_PROP)), mposjoin (a0003, a0006, ws.fetch (PRE_CONT)), ws.fetch (PROP_TEXT)); # a0002: item1(str) # End rule: "Rel: doc_access(FragList, Rel)" # Begin rule: "Rel: project(Rel)" # a0009: iter(nat) # a0002: item1(str) a0003 := unused; a0006 := unused; # End rule: "Rel: project(Rel)" # Begin rule: "Rel: project(Rel)" # a0000: iter(nat) # a0004: item1(pfrag) # a0005: item1(pre) # End rule: "Rel: project(Rel)" # Begin rule: "Rel: llscj_desc(FragList, Rel)" a0003 := loop_lifted_descendant_step_with_nsloc_test (a0000, a0005, a0004, ws, 2, "", "a"); a0006 := a0003.fetch (1); a0010 := a0003.fetch (2).materialize (a0006); # a0006: item1(pre) # a0010: item1(pfrag) a0011 := a0003.fetch (0).materialize (a0003.fetch (1)); # a0011: iter(nat) a0003 := unused; a0000 := unused; a0004 := unused; a0005 := unused; # End rule: "Rel: llscj_desc(FragList, Rel)" # Begin rule: "Rel: llscj_child(FragList, Rel)" a0000 := loop_lifted_child_step_with_nsloc_test (a0011, a0006, a0010, ws, 3, "", "p"); a0003 := a0000.fetch (1); a0004 := a0000.fetch (2).materialize (a0003); # a0003: item1(pre) # a0004: item1(pfrag) # a0005: iter(nat) a0000 := unused; a0006 := unused; a0010 := unused; a0011 := unused; # End rule: "Rel: llscj_child(FragList, Rel)" # Begin rule: "Rel: project(Rel)" # a0004: item1(pfrag) # a0003: item1(pre) a0005 := unused; # End rule: "Rel: project(Rel)" # Begin rule: "Rel: number(Rel)" # a0004: item1(pfrag) # a0003: item1(pre) a0000 := a0003.mark (1@0); # a0000: iter2(nat) # End rule: "Rel: number(Rel)" # Begin rule: "Rel: llscj_child(FragList, Rel)" a0005 := loop_lifted_child_step_with_kind_test (a0000, a0003, a0004, ws, 3, TEXT); a0006 := a0005.fetch (1); a0010 := a0005.fetch (2); # a0006: item1(pre) # a0010: item1(pfrag) a0011 := a0005.fetch (0).materialize (a0005.fetch (1)); # a0011: iter2(nat) a0005 := unused; # End rule: "Rel: llscj_child(FragList, Rel)" # Begin rule: "Rel: doc_access(FragList, Rel)" # a0006: item1(pre) # a0010: item1(pfrag) # a0011: iter2(nat) a0005 := mposjoin (mposjoin (a0006, a0010, ws.fetch (PRE_PROP)), mposjoin (a0006, a0010, ws.fetch (PRE_CONT)), ws.fetch (PROP_TEXT)); # a0005: item(str) # End rule: "Rel: doc_access(FragList, Rel)" # Begin rule: "Rel: project(Rel)" # a0011: iter2(nat) # a0005: item(str) a0006 := unused; a0010 := unused; # End rule: "Rel: project(Rel)" # Begin rule: "Rel: unq2_thetajoin(Rel, Rel)" # a0010: iter2(nat) # a0012: iter(nat) a0006 := htordered_unique_thetajoin (EQ, a0011.reverse ().leftjoin (a0005), a0009.reverse ().leftjoin (a0002), nil, nil); a0010 := a0006.mark (0(a)0).reverse (); a0010 := a0010.assert_order (); a0012 := a0006.reverse ().mark (0(a)0).reverse (); a0006 := unused; a0011 := unused; a0005 := unused; a0009 := unused; a0002 := unused; # End rule: "Rel: unq2_thetajoin(Rel, Rel)" # Begin rule: "Rel: project(Rel)" # a0010: iter2(nat) # a0012: iter(nat) # End rule: "Rel: project(Rel)" # Begin rule: "Rel: leftjoin(Rel, Rel)" a0002 := a0012.leftjoin (a0001.reverse ()); a0005 := a0002.mark (0(a)0).reverse (); a0006 := a0002.reverse ().mark (0(a)0).reverse (); a0002 := unused; a0002 := a0005.leftjoin (a0010); a0002 := a0002.reverse ().mark (0(a)0).reverse (); # a0002: iter2(nat) # a0009: iter(nat) a0011 := a0006.leftjoin (a0008); a0011 := a0011.reverse ().mark (0(a)0).reverse (); # a0011: item(pfrag) a0013 := a0006.leftjoin (a0007); a0013 := a0013.reverse ().mark (0(a)0).reverse (); # a0013: item(pre) # a0014: iter1(nat) a0005 := unused; a0006 := unused; a0010 := unused; a0012 := unused; a0008 := unused; a0007 := unused; a0001 := unused; # End rule: "Rel: leftjoin(Rel, Rel)" # Begin rule: "Rel: project(Rel)" # a0011: item(pfrag) # a0013: item(pre) # a0002: iter2(nat) a0009 := unused; a0014 := unused; # End rule: "Rel: project(Rel)" # Begin rule: "Rel: project(Rel)" # a0004: item1(pfrag) # a0003: item1(pre) # a0000: iter(nat) # End rule: "Rel: project(Rel)" # Begin rule: "Rel: leftjoin(Rel, Rel)" a0001 := a0000.leftjoin (a0002.reverse ()); a0005 := a0001.mark (0(a)0).reverse (); a0006 := a0001.reverse ().mark (0(a)0).reverse (); a0001 := unused; a0001 := a0005.leftjoin (a0004); a0001 := a0001.reverse ().mark (0(a)0).reverse (); # a0001: item1(pfrag) a0007 := a0005.leftjoin (a0003); a0007 := a0007.reverse ().mark (0(a)0).reverse (); # a0007: item1(pre) # a0008: iter(nat) a0009 := a0006.leftjoin (a0011); a0009 := a0009.reverse ().mark (0(a)0).reverse (); # a0009: item(pfrag) a0010 := a0006.leftjoin (a0013); a0010 := a0010.reverse ().mark (0(a)0).reverse (); # a0010: item(pre) # a0012: iter2(nat) a0005 := unused; a0006 := unused; a0004 := unused; a0003 := unused; a0000 := unused; a0011 := unused; a0013 := unused; a0002 := unused; # End rule: "Rel: leftjoin(Rel, Rel)" # Begin rule: "Rel: project(Rel)" # a0009: item(pfrag) # a0010: item(pre) # a0001: item1(pfrag) # a0007: item1(pre) a0008 := unused; a0012 := unused; # End rule: "Rel: project(Rel)" # Begin rule: "Rel: refine_sort(Rel)" a0000 := a0001; a0000 := a0000.CTrefine (a0007); a0000 := a0000.CTrefine (a0009); a0000 := a0000.CTrefine (a0010); a0000 := a0000.mark (0(a)0).reverse (); a0002 := a0000.leftjoin (a0009); a0002 := a0002.reverse ().mark (0(a)0).reverse (); # a0002: item(pfrag) a0003 := a0000.leftjoin (a0010); a0003 := a0003.reverse ().mark (0(a)0).reverse (); # a0003: item(pre) # a0001: item1(pfrag) # a0007: item1(pre) a0000 := unused; a0009 := unused; a0010 := unused; # End rule: "Rel: refine_sort(Rel)" # Begin rule: "Rel: number(Rel)" # a0002: item(pfrag) # a0003: item(pre) # a0001: item1(pfrag) # a0007: item1(pre) # a0000: pos(nat) # End rule: "Rel: number(Rel)" # Begin rule: "Rel: project(Rel)" # a0002: item(pfrag) # a0003: item(pre) # a0000: pos(nat) a0001 := unused; a0007 := unused; # End rule: "Rel: project(Rel)" a0004 := new (lng, void).key (true).reverse ().seqbase (0@0); a0005 := new (dbl, void).key (true).reverse ().seqbase (0@0); a0006 := new (str, void).key (true).reverse ().seqbase (0@0); a0007 := a0003; a0008 := a0002.set_kind (ELEM); a0007 := a0007.reverse ().mark (0(a)0).reverse (); a0008 := a0008.reverse ().mark (0(a)0).reverse (); print_result ("xml", ws, a0007, a0008, a0004, a0005, a0005, a0006); a0004 := unused; a0005 := unused; a0006 := unused; a0007 := unused; a0008 := unused; a0001 := unused; }); if (not(isnil(ws))) { ws_destroy (ws); } else { } if (not(isnil(a0001))) { ERROR (a0001); } else { } a0001 := unused; a0002 := unused; a0003 := unused; a0000 := unused; # End rule: "Query: serialize(FragList, Rel)"

2 2

[Monetdb-developers] Mserver is aborting
by Riham Abdel Kader 02 Oct '07

02 Oct '07

Hi all, I checked out today the MonetDB/XQuery code and Mserver is crashing whenever I try to execute MIL statements using the mclient command. More details follow. I first compile an XQuery to MIL statements using the command "pf -A" Then I execute the MIL statements with "mclient -t -l" Whenever I do so, I get the correct results but Mserver aborts after giving the following error message: Mserver: monet_tbl.mx:1743: TBL_M_decref: Assertion `p' failed. Aborted I have attached the XQuery file and the generated MIL file. Thank you and best regards, Riham -- Address: Database Group, Dept of EEMCS, University of Twente, POBox 217, 7500 AE Enschede, The Netherlands Phone: +31 (0)53 489 4628 Fax: +31 (0)53 489 2927 Email: r.abdelkader(a)ewi.utwente.nl

1 0

[Monetdb-developers] sourceforge outage
by Sjoerd Mullender 01 Oct '07

01 Oct '07

To forestall any questions, the Sourceforge stite status has this today: ( 2007-09-30 14:42:31 - Project CVS Service ) As of 2007-09-29 at 10:00PM Pacific, we have a CVS outage due to unplanned maintenance. This affects developer CVS access (including ViewVC) for projects starting with the letters m, n and q. Site status will be updated when the system becomes available again. -- Sjoerd Mullender

1 0