- developers-list - monetdb.org

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/conf monetdb5.conf.in, Aug2009, 1.61, 1.61.2.1
by Stefan Manegold 11 Aug '09

11 Aug '09

On Tue, Aug 11, 2009 at 06:49:24AM +0000, Niels Nes wrote: > Update of /cvsroot/monetdb/MonetDB5/conf > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv10254/conf > > Modified Files: > Tag: Aug2009 > monetdb5.conf.in > Log Message: > we don't want to release with the cluster optimizer enabled by default. > (please do not forward to the HEAD) I just prevented the propagation. Stefan > > U monetdb5.conf.in > Index: monetdb5.conf.in > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/conf/monetdb5.conf.in,v > retrieving revision 1.61 > retrieving revision 1.61.2.1 > diff -u -d -r1.61 -r1.61.2.1 > --- monetdb5.conf.in 25 Jul 2009 22:05:24 -0000 1.61 > +++ monetdb5.conf.in 11 Aug 2009 06:49:21 -0000 1.61.2.1 > @@ -236,9 +236,12 @@ > # sql_optimizer=inline,remap,deadcode,multiplex > > # The default pipeline > -sql_optimizer=inline,remap,evaluate,costModel,coercions,emptySet,cluster,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex > +sql_optimizer=inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex > > #experimental pipelines stressing various components > +# The cluster pipeline for Skyserver loading > +#sql_optimizer=inline,remap,evaluate,costModel,coercions,emptySet,cluster,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex > +# > # The Recycle pipeline for Skyserver > #sql_optimizer=inline,remap,evaluate,costModel,coercions,emptySet,aliases,deadcode,constants,commonTerms,joinPath,deadcode,recycle,reduce,garbageCollector,dataflow,history,multiplex > # > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > 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-4312 |

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/mal tablet.mx, , 1.208, 1.209
by Sjoerd Mullender 10 Aug '09

10 Aug '09

Was this a current-only bug or should this be backported? On 2009-08-07 16:16, Niels Nes wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/mal > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv8974/src/modules/mal > > Modified Files: > tablet.mx > Log Message: > also field numbers start at 1 (not 0) > > > U tablet.mx > Index: tablet.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/modules/mal/tablet.mx,v > retrieving revision 1.208 > retrieving revision 1.209 > diff -u -d -r1.208 -r1.209 > --- tablet.mx 7 Aug 2009 14:10:01 -0000 1.208 > +++ tablet.mx 7 Aug 2009 14:16:26 -0000 1.209 > @@ -2140,7 +2140,7 @@ > mal_set_lock(mal_contextLock,"tablet insert value"); > if ( *err == NULL){ > snprintf(buf,BUFSIZ, "value '%s' while parsing '%s' from line " BUNFMT > - " field %d not inserted, expecting type %s\n", val, s, BATcount(fmt->c)+1, c, fmt->type); > + " field %d not inserted, expecting type %s\n", val, s, BATcount(fmt->c)+1, c+1, fmt->type); > *err= GDKstrdup(buf); > } > mal_unset_lock(mal_contextLock,"tablet insert value"); > @@ -2155,7 +2155,7 @@ > } > return 0; > bunins_failed: > - snprintf(buf,BUFSIZ, "while parsing '%s' from line " BUNFMT " field %d not inserted\n", s, BATcount(fmt->c)+1, c); > + snprintf(buf,BUFSIZ, "while parsing '%s' from line " BUNFMT " field %d not inserted\n", s, BATcount(fmt->c)+1, c+1); > *err= GDKstrdup(buf); > return -1; > } > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- Sjoerd Mullender

3 2

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/mal tablet.mx, , 1.207, 1.208
by Sjoerd Mullender 10 Aug '09

10 Aug '09

Was this a current-only bug or should this be backported? On 2009-08-07 16:10, Niels Nes wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/mal > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv6865/src/modules/mal > > Modified Files: > tablet.mx > Log Message: > output correct line numbers > > > U tablet.mx > Index: tablet.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/modules/mal/tablet.mx,v > retrieving revision 1.207 > retrieving revision 1.208 > diff -u -d -r1.207 -r1.208 > --- tablet.mx 7 Aug 2009 06:25:15 -0000 1.207 > +++ tablet.mx 7 Aug 2009 14:10:01 -0000 1.208 > @@ -2140,7 +2140,7 @@ > mal_set_lock(mal_contextLock,"tablet insert value"); > if ( *err == NULL){ > snprintf(buf,BUFSIZ, "value '%s' while parsing '%s' from line " BUNFMT > - " field %d not inserted, expecting type %s\n", val, s, BATcount(fmt->c), c, fmt->type); > + " field %d not inserted, expecting type %s\n", val, s, BATcount(fmt->c)+1, c, fmt->type); > *err= GDKstrdup(buf); > } > mal_unset_lock(mal_contextLock,"tablet insert value"); > @@ -2155,7 +2155,7 @@ > } > return 0; > bunins_failed: > - snprintf(buf,BUFSIZ, "while parsing '%s' from line " BUNFMT " field %d not inserted\n", s, BATcount(fmt->c), c); > + snprintf(buf,BUFSIZ, "while parsing '%s' from line " BUNFMT " field %d not inserted\n", s, BATcount(fmt->c)+1, c); > *err= GDKstrdup(buf); > return -1; > } > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- Sjoerd Mullender

2 1

[Monetdb-developers] ODBC in Vista / Windows 2003 using Excel 2007
by Tim Wilson 06 Aug '09

06 Aug '09

Hi, Thanks for the contribution of MonetDB to the community. I have MonetDB set up on a Windows 2003 32-bit OS and am having difficulty using the ODBC driver. The message I get in Vista 32-bit when I try and add an ODBC data source in Excel 2007 is the following: "Specified driver could not be loaded due to system error 182 (MonetDB ODBC Driver)." That's as far as I get. I get this same error message on Windows XP 64-bit using Excel 2007. To troubleshoot this, I tried the ODBC directly from the Windows 2003 database host using Excel 2007 and I get a bit further. "Unable to obtain list of tables from the data source" I see that the ODBC is connecting to the database as, when I use Access 2007 from the same server, I can see the tables, but get an error message when trying to import or link to the tables. To me, it looks like the driver is not loading at all in Windows Vista 32-bit or XP 64-bit. But, in Windows 2003 32-bit, it is loading but unable to correctly access the data. I have done some searching on the Internet and tried a few recommendations but have not found a lot on this issue. MonetDB is a great product and I think it has tremendous BI potential if these issues were corrected. Is there active work on the ODBC driver? I would be happy to help out in any way. I do have C programming skills but no driver or ODBC experience. Thanks, -Tim

1 0

[Monetdb-developers] GooglePerformanceTools with MonetDB?
by Stefan de Konink 04 Aug '09

04 Aug '09

GooglePerformanceTools gives an alternative (threaded) implementation of malloc under a BSD License. Has it even been tested with MonetDB before? http://code.google.com/p/google-perftools/wiki/GooglePerformanceTools I mean, it looks very simple to use and test :) And implements the ideas I have heard before by doing memory management with big chunks of memory instead of small allocations. Stefan

3 5

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/compiler/debug logdebug.c, , 1.131, 1.132
by Stefan Manegold 04 Aug '09

04 Aug '09

Hi Tom, this looks like a bug fix to me. Shouldn't that checkin then have gone to the new Aug2009 release branch? Otherwise, this fix will surely not be in the next releases (Aug2009, Aug2009-SP1, Aug2009-SP2) ... Let me know, in case you need advice or help with back-porting this one to the Aug2009 release branch (using CVS commands, only, to prevent conflicts), and with checkin in future bug fixes to the release branch. Thanks! Stefan On Tue, Aug 04, 2009 at 08:50:10AM +0000, Tom Schreiber wrote: > Update of /cvsroot/monetdb/pathfinder/compiler/debug > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv12470/compiler/debug > > Modified Files: > logdebug.c > Log Message: > -- Fixed a small bug in the dot output for algebra plans: planheader-port-id's and their references were unaligned (causing warnings from the dot executable). > > U logdebug.c > Index: logdebug.c > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/compiler/debug/logdebug.c,v > retrieving revision 1.131 > retrieving revision 1.132 > diff -u -d -r1.131 -r1.132 > --- logdebug.c 31 Jul 2009 13:06:21 -0000 1.131 > +++ logdebug.c 4 Aug 2009 08:50:07 -0000 1.132 > @@ -2621,7 +2621,7 @@ > for (unsigned int j = 0; j < clsize (root->sem.ser_rel.items); j++) > fprintf (f, "%s <item%u> %s ", > (j ? "|" : ""), > - j, > + j + 1, > PFcol_str (clat (root->sem.ser_rel.items, j))); > fprintf (f, "}}}\"];\n" > "subgraph clusterPlan%i {\n", id); > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > 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 |

2 4

[Monetdb-developers] New stable branch created
by Sjoerd Mullender 03 Aug '09

03 Aug '09

I have created new stable branches for the upcoming release. From now on *all* bug fixes and *only* bug fixes *must* go to this new stable branch. I reserve the right to undo any changes that do not comply with this rule. All packages use the same name for the branch: Aug2009. So in each of your stable checkout directories you can do cvs update -rAug2009 to update to the new branch. I have created branches for the following packages: MonetDB MonetDB4 MonetDB5 TestTools buildtools clients geom java pathfinder sql template testing. Note that datacell is missing from this list. It is not yet released and will not be released in this round. -- Sjoerd Mullender

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/mal pcre.mx, , 1.86, 1.87
by Stefan Manegold 02 Aug '09

02 Aug '09

On Sat, Aug 01, 2009 at 03:45:42PM +0000, Fabian wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/mal > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv22620 > > Modified Files: > pcre.mx > Log Message: > Always use PCRE for case insensitive matches, even though they don't use > any wildcards. As far as I know there are no case insensitive versions > of BAT*select, so fixing that up would be more efforts than just going > through PCRE. Once / in case that turns[C out to be(come) a performance bottleneck, we could probably add a BAT(u)iselect (for string-tailed BATs, only) that is based on strcasecmp(3) with not too much efford ... Stefan > > U pcre.mx > Index: pcre.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/modules/mal/pcre.mx,v > retrieving revision 1.86 > retrieving revision 1.87 > diff -u -d -r1.86 -r1.87 > --- pcre.mx 1 Aug 2009 14:43:08 -0000 1.86 > +++ pcre.mx 1 Aug 2009 15:45:40 -0000 1.87 > @@ -1267,20 +1267,36 @@ > > if (!r) { > if (strcmp(ppat, (char*)str_nil) == 0) { > - BAT *bp = BATdescriptor(*b); > - BAT *res = NULL; > - > - if (bp == NULL) > - throw(MAL, "pcre.like", OPERATION_FAILED); > - if (us) > - res = BATuselect(bp, *pat, *pat); > - else > - res = BATselect(bp, *pat, *pat); > - > - *ret = res->batCacheid; > - BBPkeepref(res->batCacheid); > - BBPreleaseref(bp->batCacheid); > - r = MAL_SUCCEED; > + /* there is no pattern or escape involved, fall back to > + * simple (no PCRE) match */ > + /* FIXME: we have a slight problem here if we need a case > + * insensitive match, so even though there is no pattern, > + * just fall back to PCRE for the moment. If there is a > + * case insensitive BAT*select, we should use that instead */ > + if (ignore) { > + GDKfree(ppat); > + ppat = GDKmalloc(sizeof(char) * (strlen(*pat) + 3)); > + sprintf(ppat, "^%s$", *pat); > + if (us) > + r = PCREuselect(ret, &ppat, b, &ignore); > + else > + r = PCREselect(ret, &ppat, b, &ignore); > + } else { > + BAT *bp = BATdescriptor(*b); > + BAT *res = NULL; > + > + if (bp == NULL) > + throw(MAL, "pcre.like", OPERATION_FAILED); /*operation?*/ > + if (us) > + res = BATuselect(bp, *pat, *pat); > + else > + res = BATselect(bp, *pat, *pat); > + > + *ret = res->batCacheid; > + BBPkeepref(res->batCacheid); > + BBPreleaseref(bp->batCacheid); > + r = MAL_SUCCEED; > + } > } else { > if (us) > r = PCREuselect(ret, &ppat, b, &ignore); > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > 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-4312 |

3 4

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/server rel_select.mx, May2009, 1.143.2.4, 1.143.2.5
by Stefan de Konink 31 Jul '09

31 Jul '09

On Fri, 31 Jul 2009, Niels Nes wrote: Here you still asign something that could be NULL. > dnode *n = selection->h; > > - (void) where; > + if (!selection) > + return sql_error(sql, 02, "SELECT: the selection or from part is missing"); So the asignment should be after the check. Stefan

2 1

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/modules/mal/Tests All, , 1.73, 1.74
by Stefan Manegold 30 Jul '09

30 Jul '09

On Thu, Jul 30, 2009 at 06:36:20PM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/modules/mal/Tests > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv7859 > > Modified Files: > All > Log Message: > Move remote88 out of sight. It needs sql. maybe, it [cs]ould be move to the SQL tree, then? Stefan > > U All > Index: All > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/modules/mal/Tests/All,v > retrieving revision 1.73 > retrieving revision 1.74 > diff -u -d -r1.73 -r1.74 > --- All 14 Jul 2009 15:21:04 -0000 1.73 > +++ All 30 Jul 2009 18:36:16 -0000 1.74 > @@ -30,8 +30,8 @@ > remote03 > remote04 > remote06 > -remote88 > -# needs Merovingian > +# needs Merovingian and aims at SQL > +#remote88 > #remote89 > remote99 > > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > 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-4312 |

1 0