Consolidate table assertion error

[monetdb-team]

Date: 2016-03-14 22:39:44 +0100
From: @mlkersten
To: SQL devs <>
Version: 11.17.13 (Jan2014-SP1)
CC: @njnes

Last updated: 2016-04-01 09:59:45 +0200

Comment 21904

Date: 2016-03-14 22:39:44 +0100
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:44.0) Gecko/20100101 Firefox/44.0
Build Identifier:

A simple scheme to create a consolidated aggregation table causes an
assertion error to be triggered
0 0x00007f10509fb9c8 in raise () from /lib64/libc.so.6
1 0x00007f10509fd65a in abort () from /lib64/libc.so.6
2 0x00007f10509f4187 in __assert_fail_base () from /lib64/libc.so.6
3 0x00007f10509f4232 in __assert_fail () from /lib64/libc.so.6
4 0x00007f1044eaa0b9 in rel2bin_project (sql=0x7f10280145f0, rel=0x7f1028150d50, refs=0x7f10281568d0, topn=0x0)
at /export/scratch1/mk/default//package/sql/backends/monet5/rel_bin.c:2387
5 0x00007f1044eb4799 in subrel_bin (sql=0x7f10280145f0, rel=0x7f1028150d50, refs=0x7f10281568d0)
at /export/scratch1/mk/default//package/sql/backends/monet5/rel_bin.c:4589
6 0x00007f1044ea6377 in rel2bin_join (sql=0x7f10280145f0, rel=0x7f1028150db

Test added

Reproducible: Always

Comment 21911

Date: 2016-03-16 09:35:35 +0100
From: @njnes

fixed bug, ie reset variables before trying subquery - update expressions.

Comment 21912

Date: 2016-03-16 10:05:06 +0100
From: MonetDB Mercurial Repository <>

Changeset 37366aa4622f made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

fixed crash in Bug #3954, reinitialize properly after an error.

Comment 21913

Date: 2016-03-16 10:12:09 +0100
From: MonetDB Mercurial Repository <>

Changeset aa5f0e2117f6 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

improved fix for Bug #3954

Comment 21964

Date: 2016-03-25 09:59:23 +0100
From: @sjoerdmullender

Jul2015-SP3 has been released.

Comment 21994

Date: 2016-04-01 09:59:45 +0200
From: MonetDB Mercurial Repository <>

Changeset d6a360de69f3 made by Martin Kersten mk@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

Add new test for bug #3954