Date: 2013-01-20 12:16:57 +0100
From: Christian Braun <>
To: SQL devs <>
Version: 11.13.7 (Oct2012-SP2)
CC: ashishk, hcb, @njnes, @drstmane

Last updated: 2013-02-19 13:20:03 +0100

Comment 18348

Date: 2013-01-20 12:16:57 +0100
From: Christian Braun <>

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:18.0) Gecko/20100101 Firefox/18.0
Build Identifier:

Hello,
when running:
select "eId", min("timeInsert"), max("timeInsert"), count(*) from my.v where "uId" = 312459 group by "eId";
on the attached data set, mserver segfaults. With other data sets it works fine.
Regards,
Christian.

Reproducible: Always

Comment 18349

Date: 2013-01-20 12:17:26 +0100
From: Christian Braun <>

Created attachment 172
mclient session

Attached file: monetdb.txt (text/plain, 4875 bytes)
Description: mclient session

Comment 18350

Date: 2013-01-20 12:19:01 +0100
From: Christian Braun <>

Created attachment 173
test data

Attached file: data.gz (application/x-gzip, 55706 bytes)
Description: test data

Comment 18351

Date: 2013-01-20 18:24:13 +0100
From: @drstmane

Christian's logs suggest he's using Oct2012-SP2.

Comment 18352

Date: 2013-01-20 18:31:24 +0100
From: @drstmane

Also segfaults with Oct2012-SP3 (most probably in aggregation code).

Appears to work fine with Feb2013 candidate branch from Mercurial (with complete re-implementation of grouping & aggregation code).

Comment 18353

Date: 2013-01-21 01:36:16 +0100
From: @drstmane

Changeset dfe24d3e7d6b made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=dfe24d3e7d6b

Changeset description:

fixed bug #3225: since changeset [822e78b1baa5](https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=822e78b1baa5)  we need to lookup on e, not on bn

This must NOT be propagated.

Comment 18354

Date: 2013-01-21 01:38:31 +0100
From: @drstmane

Changeset 40bc241696a1 made by Stefan Manegold Stefan.Manegold@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=40bc241696a1

Changeset description:

added test for bug #3225

Comment 18355

Date: 2013-01-21 01:56:25 +0100
From: @drstmane

Thanks for the detailed bug report!

Should be fixed, now, in the Oct2012 branch in Mercurial (and was already working in the Feb2013 branch).

Chances are, though, that we are neither going to re-build the (not yet released) Oct2012-SP3 (as available for testing from http://dev.monetdb.org/downloads/testing/), nor going to release an Oct2012-SP4 before the upcoming Feb2013 release.

Comment 18518

Date: 2013-02-19 13:20:03 +0100
From: @sjoerdmullender

Feb2013 has been released.