- developers-list - monetdb.org

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/kernel aggr.mx, , 1.41, 1.42
by Stefan Manegold 29 Jan '10

29 Jan '10

On Fri, Jan 29, 2010 at 04:41:00AM +0000, Stefan de Konink wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/kernel > In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv5117 > > Modified Files: > aggr.mx > Log Message: > Fixes typo's and/or inconsistent throw references to function names. > Please propagate to stable. The standard policy is to check in bug fixes to the latest release branch; propagation will than happen automa[tgn]ically. Back-porting such changes by hand creates quite some overhead. Stefan > > > Index: aggr.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/modules/kernel/aggr.mx,v > retrieving revision 1.41 > retrieving revision 1.42 > diff -u -d -r1.41 -r1.42 > --- aggr.mx 7 Jan 2010 15:24:26 -0000 1.41 > +++ aggr.mx 29 Jan 2010 04:40:58 -0000 1.42 > @@ -276,7 +276,7 @@ > } > BBPreleaseref(b->batCacheid); > BBPreleaseref(e->batCacheid); > - throw(MAL, "aggrX3_sum.@4",GDK_EXCEPTION); > + throw(MAL, "aggrX3_prod.@4",GDK_EXCEPTION); > } > @- > @= AX3sumprod > @@ -548,7 +548,7 @@ > BBPreleaseref(b->batCacheid); > BBPreleaseref(e->batCacheid); > BBPreleaseref(g->batCacheid); > - throw(MAL, "aggrX3_prod3",GDK_EXCEPTION); > + throw(MAL, "aggrX3_avg3",GDK_EXCEPTION); > } > @c > @:AX3arithavg3(bte,loc)@ > @@ -590,7 +590,7 @@ > BBPreleaseref(b->batCacheid); > BBPreleaseref(e->batCacheid); > BBPreleaseref(g->batCacheid); > - throw(MAL, "aggrX3_prod3",GDK_EXCEPTION); > + throw(MAL, "aggrX3_@13",GDK_EXCEPTION); > } > @c > @:AX3extreme3(min,<)@ > @@ -627,7 +627,7 @@ > BBPreleaseref(b->batCacheid); > BBPreleaseref(e->batCacheid); > BBPreleaseref(g->batCacheid); > - throw(MAL, "aggrX3_prod3", GDK_EXCEPTION); > + throw(MAL, "aggrX3_count3", GDK_EXCEPTION); > } > @- > The remainder contains the few MIL proc translations > > > ------------------------------------------------------------------------------ > The Planet: dedicated and managed hosting, cloud storage, colocation > Stay online with enterprise data centers and the best network in the business > Choose flexible plans and management services without long-term contracts > Personal 24x7 support from experience hosting pros just a phone call away. > http://p.sf.net/sfu/theplanet-com > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-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-4199 |

1 0

[Monetdb-developers] Announcement: New Nov2009-SP2 bugfix release of MonetDB suite
by Sjoerd Mullender 28 Jan '10

28 Jan '10

The MonetDB team at CWI/MonetDB BV is pleased to announce the Nov2009-SP2 bug fix release of the MonetDB suite of programs. More information on this release will be available at <http://monetdb.cwi.nl/Development/Releases/Nov2009/>. Fixes include: - No need to require bash for running the *-config scripts. (SF bug #2914563) - MonetDB5 development package now contains all development include files. (SF RFE #2929558) - Added support for compiling on OpenBSD (contributed, i.e. not tested by us). - General code improvements, partly inspired by running Coverity Scan. - mclient -D will exit with a non-zero exit code if dumping failed. (SF bug #2925674) - The Python interface now uses the same socket options as the C version, giving a boost in performance. (SF bug #2925750) - Fixed a bug in the Python interface to deal with fields with embedded newline characters. (SF bug #2917219) - Added initial support to the Python client interface for specifying the encoding. - Fixed a bug in execute argument parsing in Python interface. - Added missing .sql files to the Windows installer. - In MonetDB/SQL, fixed bug in not(invalidtable). (SF bug #2927174) -- Sjoerd Mullender

1 0

[Monetdb-developers] Regarding indexes in MonetDB XQuery
by Mo Zhou 27 Jan '10

27 Jan '10

Hi, Does MonetDB XQuery support any type of structural indexes? Or caching results of a frequently queried path (with branches)? -- Thanks, M

1 0

[Monetdb-developers] mmap region resizing
by Isidor Zeuner 26 Jan '10

26 Jan '10

While figuring out some things related to memory management, I stumbled upon a line in MonetDB/src/gdk/gdk_posix.mx which I don't fully understand: munmap(p + oldsize, oldsize - newsize); ..which is called from MT_vmrealloc when the old size is larger than the new size. This would unmap a region as large as the size difference between both sizes, but after the currently mapped region [p; p + oldsize[ (which is probably not mapped, or is mapped to something unrelated). The attached patch changes this behavior so the resulting mapped region will be [p; p + newsize[, with the now unneeded [p + newsize; p + oldsize[ region being unmapped (which is a behavior I find more intuitive). Please review and use as it fits. Best regards, Isidor Zeuner

1 0

[Monetdb-developers] GDKupgradevarheap allocate/copy inconsistency
by Isidor Zeuner 23 Jan '10

23 Jan '10

Dear MonetDB developers, please see the newly created tracker item [1]. I haven't seen relevant design documentation which would have allowed me to deduce if BATs from VIEWcreate_ are actually supposed to end up in GDKupgradevarheap, as it happened to me. Still, I could imagine the suggested fix to be a step in the right direction as it helps modularity by making the function working with less preassumptions on the inputs. However, if it fits into the global design, the capacity argument can (should?) be removed from the function signature. Best regards, Isidor Zeuner [1] https://sourceforge.net/tracker/?func=detail&aid=2936616&group_id=56967&ati…

3 6

[Monetdb-developers] sql_delta ibase issue
by Isidor Zeuner 21 Jan '10

21 Jan '10

Dear MonetDB developers, using MonetDB-SQL Feb2010, I occasionally encounter this error message: bat_storage.mx:1274: tr_update_delta: Assertion `obat->ibase == cbat->ibase' failed It occurs only seldomly, so I'll probably not have an isolated test case all too soon. I wonder if someone with more insight into the SQL engine has some pointers on where to look at. Many thanks, Isidor Zeuner

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/mal groupby.mx, , 1.2, 1.3
by Lefteris 17 Jan '10

17 Jan '10

it still calls GROUPmin and not GROUPavg is that the intention? On Sun, Jan 17, 2010 at 8:32 PM, Niels Nes <nielsnes(a)users.sourceforge.net> wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/mal > In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv30908/src/modules/mal > > Modified Files: > groupby.mx > Log Message: > fix cut/paste bug > > > Index: groupby.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/modules/mal/groupby.mx,v > retrieving revision 1.2 > retrieving revision 1.3 > diff -u -d -r1.2 -r1.3 > --- groupby.mx 7 Jan 2010 15:24:26 -0000 1.2 > +++ groupby.mx 17 Jan 2010 19:32:16 -0000 1.3 > @@ -74,7 +74,7 @@ > > pattern avg(pivot:bat[:oid,:any_1],b:bat[:oid,:any_2]...) :bat[:oid,:any_2] > address GROUPmin > -comment "Derive the grouping of all tuples in the BATs and determine minimum value. > +comment "Derive the grouping of all tuples in the BATs and determine average value. > The group oid is materialized."; > > @- > > > ------------------------------------------------------------------------------ > Throughout its 18-year history, RSA Conference consistently attracts the > world's best and brightest in the field, creating opportunities for Conference > attendees to learn about information security's most important issues through > interactions with peers, luminaries and emerging and established companies. > http://p.sf.net/sfu/rsaconf-dev2dev > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins >

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/kernel algebra.mx, , 1.231, 1.232
by Lefteris 17 Jan '10

17 Jan '10

I guess this has been since the dawn of time there:) The thing is that I am implementing standard deviation support on the aggregation functions and this new functionality goes in the dev head, thats why this commit went there too. I am trying to stay clear from stable branches for now On Sun, Jan 17, 2010 at 11:48 AM, Sjoerd Mullender <sjoerd(a)acm.org> wrote: > Wouldn't this have been appropriate on one of the branches? I'd even go > so far as suggesting the Nov2009 branch. > > On 2010-01-17 11:40, Lefteris Sidirourgos wrote: >> Update of /cvsroot/monetdb/MonetDB5/src/modules/kernel >> In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv5751 >> >> Modified Files: >> algebra.mx >> Log Message: >> We export the algebra avg functions twice. there is no need for that, so delete one of the two export statements >> >> >> Index: algebra.mx >> =================================================================== >> RCS file: /cvsroot/monetdb/MonetDB5/src/modules/kernel/algebra.mx,v >> retrieving revision 1.231 >> retrieving revision 1.232 >> diff -u -d -r1.231 -r1.232 >> --- algebra.mx 12 Jan 2010 09:13:49 -0000 1.231 >> +++ algebra.mx 17 Jan 2010 10:40:06 -0000 1.232 >> @@ -1081,17 +1081,6 @@ >> algebra_export str ALGidentity(int *ret, int *bid); >> algebra_export str ALGmaterialize(int *ret, int *bid); >> algebra_export str ALGreuse(int *ret, int *bid); >> - >> -@= avg_export >> -algebra_export str ALGavg_@1(dbl *res, int *bid) { >> -@h >> -@:avg_export(bte)@ >> -@:avg_export(sht)@ >> -@:avg_export(int)@ >> -@:avg_export(wrd)@ >> -@:avg_export(lng)@ >> -@:avg_export(flt)@ >> -@:avg_export(dbl)@ >> #endif >> @c >> #include "mal_config.h" >> >> >> ------------------------------------------------------------------------------ >> Throughout its 18-year history, RSA Conference consistently attracts the >> world's best and brightest in the field, creating opportunities for Conference >> attendees to learn about information security's most important issues through >> interactions with peers, luminaries and emerging and established companies. >> http://p.sf.net/sfu/rsaconf-dev2dev >> _______________________________________________ >> Monetdb-checkins mailing list >> Monetdb-checkins(a)lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/monetdb-checkins > > > -- > Sjoerd Mullender > > ------------------------------------------------------------------------------ > Throughout its 18-year history, RSA Conference consistently attracts the > world's best and brightest in the field, creating opportunities for Conference > attendees to learn about information security's most important issues through > interactions with peers, luminaries and emerging and established companies. > http://p.sf.net/sfu/rsaconf-dev2dev > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins >

2 1

[Monetdb-developers] MonetDB/XQuery on Ruby with DataMapper
by Tinco Andringa 17 Jan '10

17 Jan '10

Darn, just when I decided to announce my port of the monetdb-ruby-sql gem to xquery, you release a fix of your own :P Anyway it's here: http://github.com/d-snp/ruby-monetdb-xquery There's still some differences between the official one and mine, I think mine handles errors a bit more gracefully, but it could be I missed something. I will look at the other changes as soon as possible to see if mine has any odd behaviour. In the following weeks I will be working on making XQuery and MonetDB work on DataMapper (since DataMapper is a nicer framework than ActiveRecord, and also ActiveRecord depends heavily on SQL) If anyone has any comments on this or any questions or would like to help out then please let me hear. I plan on putting the datamapper implementation on github too somewhere this week. Kind regards, Tinco Andringa

2 2

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/modules/pftijah pftijah_stem.mx, , 1.15, 1.16
by Stefan Manegold 15 Jan '10

15 Jan '10

On Fri, Jan 15, 2010 at 03:54:05PM +0000, Henning Rode wrote: > Update of /cvsroot/monetdb/pathfinder/modules/pftijah > In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv4282 > > Modified Files: > pftijah_stem.mx > Log Message: > remove dublicates from stopword list Is this a new feature for the May2010 release, or should this rather be a bug fix for the Feb2010 release? Stefan > > Index: pftijah_stem.mx > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/modules/pftijah/pftijah_stem.mx,v > retrieving revision 1.15 > retrieving revision 1.16 > diff -u -d -r1.15 -r1.16 > --- pftijah_stem.mx 20 Apr 2009 23:30:46 -0000 1.15 > +++ pftijah_stem.mx 15 Jan 2010 15:54:03 -0000 1.16 > @@ -135,7 +135,6 @@ > "does",\ > "done",\ > "down",\ > -"down",\ > "downed",\ > "downing",\ > "downs",\ > @@ -208,8 +207,6 @@ > "here",\ > "herself",\ > "high",\ > -"high",\ > -"high",\ > "higher",\ > "highest",\ > "him",\ > @@ -284,7 +281,6 @@ > "needs",\ > "never",\ > "new",\ > -"new",\ > "newer",\ > "newest",\ > "next",\ > @@ -351,7 +347,6 @@ > "rather",\ > "really",\ > "right",\ > -"right",\ > "room",\ > "rooms",\ > "s",\ > @@ -391,7 +386,6 @@ > "state",\ > "states",\ > "still",\ > -"still",\ > "such",\ > "sure",\ > "t",\ > > > ------------------------------------------------------------------------------ > Throughout its 18-year history, RSA Conference consistently attracts the > world's best and brightest in the field, creating opportunities for Conference > attendees to learn about information security's most important issues through > interactions with peers, luminaries and emerging and established companies. > http://p.sf.net/sfu/rsaconf-dev2dev > _______________________________________________ > 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-4199 |

2 1