- developers-list - monetdb.org

Re: MonetDB: default - Removed Alex's array implementation
by Ying Zhang 05 Aug '14

05 Aug '14

Dear all, I probably have broken Mtest.py with this changeset, since Mtest.py doesn't work for me any more just after this changeset. But I don't see what I did wrong. Does anyone have an idea? Thanks! Jennie On Aug 05, 2014, at 12:35, Jennie Zhang <commits(a)monetdb.org> wrote: > Changeset: b62643655146 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b62643655146 > Removed Files: > monetdb5/mal/Tests/tst267.mal > monetdb5/mal/Tests/tst267.stable.err > monetdb5/mal/Tests/tst267.stable.out > monetdb5/modules/kernel/array.c > monetdb5/modules/kernel/array.h > monetdb5/modules/kernel/array.mal > monetdb5/optimizer/Tests/AEexample.mal > monetdb5/optimizer/Tests/AEexample.stable.err > monetdb5/optimizer/Tests/AEexample.stable.out > monetdb5/optimizer/Tests/GCexample.mal > monetdb5/optimizer/Tests/GCexample.stable.err > monetdb5/optimizer/Tests/GCexample.stable.out > monetdb5/optimizer/Tests/tst4800.mal > monetdb5/optimizer/Tests/tst4800.stable.err > monetdb5/optimizer/Tests/tst4800.stable.out > monetdb5/optimizer/Tests/tst4801.mal > monetdb5/optimizer/Tests/tst4801.stable.err > monetdb5/optimizer/Tests/tst4801.stable.out > monetdb5/optimizer/Tests/tst4810.mal > monetdb5/optimizer/Tests/tst4810.stable.err > monetdb5/optimizer/Tests/tst4810.stable.out > monetdb5/optimizer/Tests/tst4900.mal > monetdb5/optimizer/Tests/tst4900.stable.err > monetdb5/optimizer/Tests/tst4900.stable.out > Modified Files: > clients/Tests/MAL-signatures.stable.out > clients/Tests/MAL-signatures_gsl.stable.out > clients/Tests/MAL-signatures_nocfitsio.stable.out > clients/Tests/MAL-signatures_sphinxclient.stable.out > clients/Tests/exports.stable.out > monetdb5/modules/kernel/Makefile.ag > Branch: default > Log Message: > > Removed Alex's array implementation > > > diffs (truncated from 2760 to 300 lines): > > diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out > --- a/clients/Tests/MAL-signatures.stable.out > +++ b/clients/Tests/MAL-signatures.stable.out > @@ -2849,46 +2849,6 @@ command alarm.usec{unsafe}():lng > address ALARMusec; > comment return cpu microseconds info > > -command array.grid(b:bat[:oid,:lng],i:lng,j:lng,k:lng,l:lng,s:lng):bat[:oid,:lng] > -address ARRAYgridBATshift_lng; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elemenets with a factor s > - > -command array.grid(b:bat[:oid,:lng],i:lng,j:lng,k:lng,l:lng):bat[:oid,:lng] > -address ARRAYgridBAT_lng; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.grid(i:lng,j:lng,k:lng,l:lng,s:lng):bat[:oid,:lng] > -address ARRAYgridShift_lng; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elements with a factor s > - > -command array.grid(i:lng,j:lng,k:lng,l:lng):bat[:oid,:lng] > -address ARRAYgrid_lng; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.grid(b:bat[:oid,:int],i:int,j:int,k:int,l:int,s:int):bat[:oid,:int] > -address ARRAYgridBATshift_int; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elemenets with a factor s > - > -command array.grid(b:bat[:oid,:int],i:int,j:int,k:int,l:int):bat[:oid,:int] > -address ARRAYgridBAT_int; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.grid(i:int,j:int,k:int,l:int,s:int):bat[:oid,:int] > -address ARRAYgridShift_int; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elements with a factor s > - > -command array.grid(i:int,j:int,k:int,l:int):bat[:oid,:int] > -address ARRAYgrid_int; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.project(b:bat[:oid,:any_1],i:int):bat[:oid,:int] > -address ARRAYproject; > -comment Fill an array representation with constants > - > -command array.product(b:bat[:oid,:any_1],c:bat[:oid,:any_2]) (X_3:bat[:oid,:any_1],c:bat[:oid,:any_2]) > -address ARRAYproduct; > -comment Produce an array product > - > command batudf.fuse(one:bat[:oid,:int],two:bat[:oid,:int]):bat[:oid,:lng] > address UDFBATfuse; > comment fuse two (4-byte) int values into one (8-byte) lng value > diff --git a/clients/Tests/MAL-signatures_gsl.stable.out b/clients/Tests/MAL-signatures_gsl.stable.out > --- a/clients/Tests/MAL-signatures_gsl.stable.out > +++ b/clients/Tests/MAL-signatures_gsl.stable.out > @@ -2849,46 +2849,6 @@ command alarm.usec{unsafe}():lng > address ALARMusec; > comment return cpu microseconds info > > -command array.grid(b:bat[:oid,:lng],i:lng,j:lng,k:lng,l:lng,s:lng):bat[:oid,:lng] > -address ARRAYgridBATshift_lng; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elemenets with a factor s > - > -command array.grid(b:bat[:oid,:lng],i:lng,j:lng,k:lng,l:lng):bat[:oid,:lng] > -address ARRAYgridBAT_lng; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.grid(i:lng,j:lng,k:lng,l:lng,s:lng):bat[:oid,:lng] > -address ARRAYgridShift_lng; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elements with a factor s > - > -command array.grid(i:lng,j:lng,k:lng,l:lng):bat[:oid,:lng] > -address ARRAYgrid_lng; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.grid(b:bat[:oid,:int],i:int,j:int,k:int,l:int,s:int):bat[:oid,:int] > -address ARRAYgridBATshift_int; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elemenets with a factor s > - > -command array.grid(b:bat[:oid,:int],i:int,j:int,k:int,l:int):bat[:oid,:int] > -address ARRAYgridBAT_int; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.grid(i:int,j:int,k:int,l:int,s:int):bat[:oid,:int] > -address ARRAYgridShift_int; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elements with a factor s > - > -command array.grid(i:int,j:int,k:int,l:int):bat[:oid,:int] > -address ARRAYgrid_int; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.project(b:bat[:oid,:any_1],i:int):bat[:oid,:int] > -address ARRAYproject; > -comment Fill an array representation with constants > - > -command array.product(b:bat[:oid,:any_1],c:bat[:oid,:any_2]) (X_3:bat[:oid,:any_1],c:bat[:oid,:any_2]) > -address ARRAYproduct; > -comment Produce an array product > - > command batudf.fuse(one:bat[:oid,:int],two:bat[:oid,:int]):bat[:oid,:lng] > address UDFBATfuse; > comment fuse two (4-byte) int values into one (8-byte) lng value > diff --git a/clients/Tests/MAL-signatures_nocfitsio.stable.out b/clients/Tests/MAL-signatures_nocfitsio.stable.out > --- a/clients/Tests/MAL-signatures_nocfitsio.stable.out > +++ b/clients/Tests/MAL-signatures_nocfitsio.stable.out > @@ -2849,46 +2849,6 @@ command alarm.usec{unsafe}():lng > address ALARMusec; > comment return cpu microseconds info > > -command array.grid(b:bat[:oid,:lng],i:lng,j:lng,k:lng,l:lng,s:lng):bat[:oid,:lng] > -address ARRAYgridBATshift_lng; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elemenets with a factor s > - > -command array.grid(b:bat[:oid,:lng],i:lng,j:lng,k:lng,l:lng):bat[:oid,:lng] > -address ARRAYgridBAT_lng; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.grid(i:lng,j:lng,k:lng,l:lng,s:lng):bat[:oid,:lng] > -address ARRAYgridShift_lng; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elements with a factor s > - > -command array.grid(i:lng,j:lng,k:lng,l:lng):bat[:oid,:lng] > -address ARRAYgrid_lng; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.grid(b:bat[:oid,:int],i:int,j:int,k:int,l:int,s:int):bat[:oid,:int] > -address ARRAYgridBATshift_int; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elemenets with a factor s > - > -command array.grid(b:bat[:oid,:int],i:int,j:int,k:int,l:int):bat[:oid,:int] > -address ARRAYgridBAT_int; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.grid(i:int,j:int,k:int,l:int,s:int):bat[:oid,:int] > -address ARRAYgridShift_int; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elements with a factor s > - > -command array.grid(i:int,j:int,k:int,l:int):bat[:oid,:int] > -address ARRAYgrid_int; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.project(b:bat[:oid,:any_1],i:int):bat[:oid,:int] > -address ARRAYproject; > -comment Fill an array representation with constants > - > -command array.product(b:bat[:oid,:any_1],c:bat[:oid,:any_2]) (X_3:bat[:oid,:any_1],c:bat[:oid,:any_2]) > -address ARRAYproduct; > -comment Produce an array product > - > command batudf.fuse(one:bat[:oid,:int],two:bat[:oid,:int]):bat[:oid,:lng] > address UDFBATfuse; > comment fuse two (4-byte) int values into one (8-byte) lng value > diff --git a/clients/Tests/MAL-signatures_sphinxclient.stable.out b/clients/Tests/MAL-signatures_sphinxclient.stable.out > --- a/clients/Tests/MAL-signatures_sphinxclient.stable.out > +++ b/clients/Tests/MAL-signatures_sphinxclient.stable.out > @@ -2849,46 +2849,6 @@ command alarm.usec{unsafe}():lng > address ALARMusec; > comment return cpu microseconds info > > -command array.grid(b:bat[:oid,:lng],i:lng,j:lng,k:lng,l:lng,s:lng):bat[:oid,:lng] > -address ARRAYgridBATshift_lng; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elemenets with a factor s > - > -command array.grid(b:bat[:oid,:lng],i:lng,j:lng,k:lng,l:lng):bat[:oid,:lng] > -address ARRAYgridBAT_lng; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.grid(i:lng,j:lng,k:lng,l:lng,s:lng):bat[:oid,:lng] > -address ARRAYgridShift_lng; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elements with a factor s > - > -command array.grid(i:lng,j:lng,k:lng,l:lng):bat[:oid,:lng] > -address ARRAYgrid_lng; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.grid(b:bat[:oid,:int],i:int,j:int,k:int,l:int,s:int):bat[:oid,:int] > -address ARRAYgridBATshift_int; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elemenets with a factor s > - > -command array.grid(b:bat[:oid,:int],i:int,j:int,k:int,l:int):bat[:oid,:int] > -address ARRAYgridBAT_int; > -comment Fills an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.grid(i:int,j:int,k:int,l:int,s:int):bat[:oid,:int] > -address ARRAYgridShift_int; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset)and shift all elements with a factor s > - > -command array.grid(i:int,j:int,k:int,l:int):bat[:oid,:int] > -address ARRAYgrid_int; > -comment Generates an index BAT, (grpcount,grpsize,clustersize,offset) > - > -command array.project(b:bat[:oid,:any_1],i:int):bat[:oid,:int] > -address ARRAYproject; > -comment Fill an array representation with constants > - > -command array.product(b:bat[:oid,:any_1],c:bat[:oid,:any_2]) (X_3:bat[:oid,:any_1],c:bat[:oid,:any_2]) > -address ARRAYproduct; > -comment Produce an array product > - > command batudf.fuse(one:bat[:oid,:int],two:bat[:oid,:int]):bat[:oid,:lng] > address UDFBATfuse; > comment fuse two (4-byte) int values into one (8-byte) lng value > diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out > --- a/clients/Tests/exports.stable.out > +++ b/clients/Tests/exports.stable.out > @@ -838,21 +838,6 @@ str ALGuselect1(int *result, int *bid, p > str ALGuselectInclusive(int *result, int *bid, ptr low, ptr high, bit *lin, bit *rin); > str ALGvariance(dbl *res, int *bid); > str ALGvariancep(dbl *res, int *bid); > -str ARRAYgridBAT_int(int *ret, int *bid, int *groups, int *groupsize, int *clustersize, int *offset); > -str ARRAYgridBAT_lng(lng *ret, lng *bid, lng *groups, lng *groupsize, lng *clustersize, lng *offset); > -str ARRAYgridBATshift_int(int *ret, int *bid, int *groups, int *groupsize, int *clustersize, int *offset, int *shift); > -str ARRAYgridBATshift_lng(lng *ret, lng *bid, lng *groups, lng *groupsize, lng *clustersize, lng *offset, lng *shift); > -str ARRAYgridShift_int(int *ret, int *groups, int *groupsize, int *clustersize, int *offset, int *shift); > -str ARRAYgridShift_lng(lng *ret, lng *groups, lng *groupsize, lng *clustersize, lng *offset, lng *shift); > -str ARRAYgrid_int(int *ret, int *groups, int *groupsize, int *clustersize, int *offset); > -str ARRAYgrid_lng(lng *ret, lng *groups, lng *groupsize, lng *clustersize, lng *offset); > -str ARRAYmultiply_int_int(int *ret, int *bid, int *rid); > -str ARRAYmultiply_int_lng(int *ret, int *bid, int *rid); > -str ARRAYmultiply_lng_lng(int *ret, int *bid, int *rid); > -str ARRAYmultiply_sht_int(int *ret, int *bid, int *rid); > -str ARRAYmultiply_sht_lng(int *ret, int *bid, int *rid); > -str ARRAYproduct(int *ret, int *ret2, int *bid, int *rid); > -str ARRAYproject(int *ret, int *bid, int *cst); > str AUTHaddUser(oid *ret, Client *c, str *user, str *pass); > str AUTHchangePassword(Client *c, str *oldpass, str *passwd); > str AUTHchangeUsername(Client *c, str *olduser, str *newuser); > diff --git a/monetdb5/mal/Tests/tst267.mal b/monetdb5/mal/Tests/tst267.mal > deleted file mode 100644 > --- a/monetdb5/mal/Tests/tst267.mal > +++ /dev/null > @@ -1,14 +0,0 @@ > -# Grouped sums > -a:= bat.new(:oid,:int); > -b:= bat.new(:oid,:int); > -bat.append(a,1); > -bat.append(a,2); > -bat.append(b,5); > -bat.append(b,6); > -bat.append(b,7); > -bat.append(b,8); > -io.print(a); > -io.print(b); > - > -(g,h):= array.product(a,b); > -io.print(g,h); > diff --git a/monetdb5/mal/Tests/tst267.stable.err b/monetdb5/mal/Tests/tst267.stable.err > deleted file mode 100644 > --- a/monetdb5/mal/Tests/tst267.stable.err > +++ /dev/null > @@ -1,12 +0,0 @@ > -stderr of test 'tst267` in directory 'monetdb5/mal` itself: > - > - > -# 20:55:59 > > -# 20:55:59 > Mtimeout -timeout 60 Mserver "--config=/ufs/mk/monet5/src/mal/Tests/All.conf" --debug=10 --set "monet_mod_path=/ufs/mk/monet5/Linux/lib/MonetDB5:/ufs/mk/opensource/MonetDB/Linux/lib/MonetDB" --set "gdk_dbfarm=/ufs/mk/opensource/MonetDB/Linux/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/mk/opensource/MonetDB/Linux/var/MonetDB5/log" --set mapi_port=40036 --set sql_port=52173 --set monet_prompt= --trace "--config=/ufs/mk/monet5/src/mal/Tests/All.conf" --dbname=mTests_src_mal tst267.mal </dev/null > -# 20:55:59 > > - > - > -# 20:55:59 > > -# 20:55:59 > Done. > -# 20:55:59 > > - > diff --git a/monetdb5/mal/Tests/tst267.stable.out b/monetdb5/mal/Tests/tst267.stable.out > deleted file mode 100644 > --- a/monetdb5/mal/Tests/tst267.stable.out > +++ /dev/null > @@ -1,72 +0,0 @@ > -stdout of test 'tst267` in directory 'monetdb5/mal` itself: > - > - > -# 20:55:59 > > -# 20:55:59 > Mtimeout -timeout 60 Mserver "--config=/ufs/mk/monet5/src/mal/Tests/All.conf" --debug=10 --set "monet_mod_path=/ufs/mk/monet5/Linux/lib/MonetDB5:/ufs/mk/opensource/MonetDB/Linux/lib/MonetDB" --set "gdk_dbfarm=/ufs/mk/opensource/MonetDB/Linux/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/mk/opensource/MonetDB/Linux/var/MonetDB5/log" --set mapi_port=40036 --set sql_port=52173 --set monet_prompt= --trace "--config=/ufs/mk/monet5/src/mal/Tests/All.conf" --dbname=mTests_src_mal tst267.mal </dev/null > -# 20:55:59 > > - > -# Monet Database Server V4.7.0 > -# Copyright (c) 1993-2005, CWI. All rights reserved. > -# Compiled for i686-redhat-linux-gnu/32bit; dynamically linked. > -# config:/ufs/mk/monet5/src/mal/Tests/All.conf > -# dbfarm:/ufs/mk/opensource/MonetDB/Linux/var/MonetDB5/dbfarm > -# dbname:mTests_src_mal > -# Visit http://monetdb.cwi.nl/ for further information. > -## Grouped sums > -#a:= new(:void,:int); > -#setSequenceBase(a,0:oid); > -#b:= new(:void,:int); > -#setSequenceBase(b,0:oid); > -#insert(a,1); > -#insert(a,2); > -#insert(b,3); > -#insert(b,4); > -#insert(b,5); > -#print(a); > -#print(b); > -# > -#g:= array.*(a,b); > -#print(g); > -# > -function user.main():void; > -# Grouped sums > - a := bat.new(:oid,:int); > - b := bat.new(:oid,:int); > _______________________________________________ > checkin-list mailing list > checkin-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/checkin-list

2 1

Announcement: New Jan2014-SP3 Bugfix release of MonetDB suite
by Sjoerd Mullender 31 Jul '14

31 Jul '14

The MonetDB team at CWI/MonetDB BV is pleased to announce the Jan2014-SP3 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at <http://www.monetdb.org/>. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. Jan 2014-SP3 bugfix release Build Environment * Fix configure to continue without Python if the python binary is too old. This instead of always aborting configure if python happens to be too old. Bug Fixes * 3487: dead link to "Professional services" * 3500: MonetDB driver wants an empty string for SQLTables and SQLColumns API calls, where other drivers expect NULL * 3514: mserver5 crash due (assertion failure in gdk_select.c) * 3515: mserver5 crash due (assertion failure in gdk_bat.c) * 3519: Uppercase TRUE/FALSE strings cannot be converted to boolean values

1 0

Re: MonetDB: transaction-replication - Silence compiler
by Sjoerd Mullender 21 Jul '14

21 Jul '14

Not the right fix. __int64_t is not portable. In this case, since strings are never so long, a cast to (int) would have been good enough. You could also use ptrdiff_t which is the actual (standard C) type for the difference of pointers. On 2014-07-20 21:52, Dimitar Nedev wrote: > Changeset: 697c8e1dfbac for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=697c8e1dfbac > Modified Files: > gdk/gdk_storage.c > Branch: transaction-replication > Log Message: > > Silence compiler > Avoid conversion from int64 to int > > > diffs (21 lines): > > diff --git a/gdk/gdk_storage.c b/gdk/gdk_storage.c > --- a/gdk/gdk_storage.c > +++ b/gdk/gdk_storage.c > @@ -100,7 +100,7 @@ GDKfilepath(int farmid, const char *dir, > char * > GDKfilepath_long(int farmid, const char *dir, const char *ext) { > char *last_dir_with_sep; > - int last_dirsep_index; > + __int64_t last_dirsep_index; > char *last_dir; > char *last_dir_parent; > > @@ -258,7 +258,7 @@ GDKfileopen(int farmid, const char * dir > /* if name is null, try to get one from dir (in case it was a path) */ > if ((name == NULL) || (*name == 0)) { > char *last_dir_with_sep; > - int last_dirsep_index; > + __int64_t last_dirsep_index; > char *last_dir; > char *last_dir_parent; > > _______________________________________________ > checkin-list mailing list > checkin-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/checkin-list > -- Sjoerd Mullender

2 1

Announcement: New Jan2014-SP2 Bugfix release of MonetDB suite
by Sjoerd Mullender 02 Jun '14

02 Jun '14

The MonetDB team at CWI/MonetDB BV is pleased to announce the Jan2014-SP2 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at <http://www.monetdb.org/>. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. Jan 2014-SP2 bugfix release Build Environment * Lots of minor fixes were made for potential defects found by Coverity Scan. * On Windows we now build the geom module against version 3.4.2 of the geos library. Client Package * ODBC: Implemented {call procedure-name(...)} escape. The version {?=call ...} is not implemented. Bug Fixes * 3424: numeric values at the front of strings determines whether CAST works successfully * 3439: Python driver drops milliseconds from timestamps * 3446: SET READ ONLY forgets previous changes * 3455: String columns unusable from 64-bit .NET via ODBC * 3456: Insert fails * 3457: When kernel of remote client crashes, the connection remains established on server side * 3458: mserver5 crash on SQL: SELECT COUNT(*) FROM SYS.TABLES HAVING COUNT(*) > 0 * 3461: mserver5 crash on SQL: SELECT * FROM SYS.ARGS WHERE FUNC_ID NOT IN (SELECT ID FROM SYS.FUNCTIONS) OR FUNC_ID NOT IN (SELECT * FROM SYS.FUNCTIONS) * 3462: Invalid SQL (IN with subquery which returns multiple columns) is accepted * 3463: Crash on SELECT with SERIAL aggregation and GROUP BY column alias's * 3468: Local temporary table persists across sessions * 3469: Absolute network paths considered invalid for COPY INTO ... FROM statement. * 3473: Various memory leaks in SQL compilation * 3477: ODBC driver raises "unexpected end of input" for prepared string parameter from .NET application * 3481: Cannot run multiple COPY INTO statements in one 's'-command * 3482: Crossproduct error

2 1

TPC-H in MALs
by Qing Guo 21 Apr '14

21 Apr '14

Hi, I was trying to run “mserver” (standalone) in a simulator to do some performance study. As mserver only reads MALs, are there any ready-to-use MAL scripts for TPC-H? I tried to use “explain” in “mclient”, but the translated MALs seem to be too detailed and cannot simply copy and run. Any idea on this? Thank you! -Kevin

1 0

headless documentation
by Fabian Groffen 14 Mar '14

14 Mar '14

Hi devs, Is there any documentation for headless? Not that it seems completely pointless, but how exactly is it supposed to work? I'm looking for documentation that explains why, but preferably also old situation and how it should be converted into new situation kind of examples. Things like: can I simply insert into a void-headed BAT to automatically create a BAT with gaps if I e.g. insert 1, 5 and 7. Can I do a selection on the head (which should be a simple offset jump) to easily retrieve its tail, and how does the subselect interface exactly work. There appears to be not even comments on this piece of code. Regards from Fuerteventura, Fabian

2 1

Re: MonetDB: Jan2014 - configure.ag: revised way to determine compil...
by Fabian Groffen 11 Mar '14

11 Mar '14

On 05-03-2014 08:25:38 +0100, Stefan Manegold wrote: > Changeset: 36afc568f849 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=36afc568f849 > Modified Files: > configure.ag > Branch: Jan2014 > Log Message: > > configure.ag: revised way to determine compiler type (gcc vs. clang vs. icc): > in particular do not (only) rely on the result of AC_PROG_CC() (i.e., $GCC) > or the name of the call; > background is that on Mac OSX Mavericks, Apple prestends that their clang > were gcc ... FYI: they were pretending they had a GCC since OSX Lion. Fabian

4 14

Announcement: New Jan2014-SP1 Bugfix release of MonetDB suite
by Sjoerd Mullender 10 Mar '14

10 Mar '14

The MonetDB team at CWI/MonetDB BV is pleased to announce the Jan2014-SP1 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at <http://www.monetdb.org/>. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. Jan 2014-SP1 bugfix release Build Environment * Configure now enables the SQL front end by default. Merovingian * monetdb destroy -f now also works on running databases Bug Fixes * 3442: COPY INTO ... LOCKED reports incorrect count * 3443: DROP INDEX crashes server with BATsubselect: invalid argument: b must have a dense head * 3444: AND after ON () of LEFT OUTER JOIN with certain expressions will cause crash * 3452: ODBC driver build fails on Mac OS X due to a conflicting types for the SQLColAttribute with the unixODBC library

1 0

Re: MonetDB: Jan2014 - configure: don't choke on deprecation messages
by Stefan Manegold 06 Mar '14

06 Mar '14

Hi Fabian, thank you very much for your fix! Do I understand correctly that the problem is in fact related to (recent versions of) MacOSX, and the packages / libraries that come with it, rather than the compiler itself? If so, we might want to consider adding option "-Wno-deprecated-declarations" only on (the respective versions of) MacOSX, --- or only when there is Apple's CommonCrypto API rather than OpenSSL, provided we can easily detect that --- rather than whenever using any version of clang on any system (and with old versions of gcc on any system). Yes, I still have the ambition to disable strict compilation checks only as selectively as possible, even on "odd" platforms ... ;-) Thanks! Stefan ----- Original Message ----- > Changeset: b4d844547d39 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b4d844547d39 > Modified Files: > configure.ag > Branch: Jan2014 > Log Message: > > configure: don't choke on deprecation messages > > Apple "deprecated" OpenSSL since Lion, don't complain about that. > > > diffs (15 lines): > > diff --git a/configure.ag b/configure.ag > --- a/configure.ag > +++ b/configure.ag > @@ -598,8 +598,11 @@ yes-*-*) > dnl not all) false positives, though, as well as in > dnl YACC/BISON-generated code; thus, we do not use > dnl "-Wunreachable-code" with clang and gcc < 4.5 . > + dnl At the same time, Apple deprecated OpenSSL in favour of > + dnl their own CommonCrypto API. We don't mind about that. > case "$CC_ver" in > clang-*|gcc-[[0-3]].*|gcc-4.[[0-4]].*) > + MCHECK_ADD_FLAG([-Wno-deprecated-declarations]) > ;; > *) > MCHECK_ADD_FLAG([-Wunreachable-code]) > _______________________________________________ > checkin-list mailing list > checkin-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/checkin-list > -- | Stefan.Manegold(a)CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

2 1

Re: MonetDB: Jan2014 - configure.ag: with clang, disable -pthread as...
by Fabian Groffen 05 Mar '14

05 Mar '14

On 05-03-2014 08:25:38 +0100, Stefan Manegold wrote: > Changeset: a06afa30eeea for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a06afa30eeea > Modified Files: > configure.ag > Branch: Jan2014 > Log Message: > > configure.ag: with clang, disable -pthread as compiler option > (but keep it as linker option) > > Also clang 3.3 on fedora 20 appears to work fine without > -pthread as compiler option (but requires it as linker option). from man gcc: -pthread Adds support for multithreading with the pthreads library. This option sets flags for both the preprocessor and linker. This is typically something like _REENTRANT. On Mountain Lion, gcc/clang would set _REENTRANT. Same for CentOS 6. % /usr/bin/gcc -dumpspecs | grep pthread %{static:%{!dynamic:-D__STATIC__}}%{!static:-D__DYNAMIC__} %%{pthread:-D_REENTRANT} What I can imagine here, is that because clang on Mavericks now defaults to C99 mode (instead of gnu89 mode gcc defaults to) you get different defines and behaviour, possibly including _REENTRANT. A preprocessor check would have to give some facts around that. Fabian

1 0