Assertion failure in rel_bin.c

[monetdb-team]

Date: 2019-09-06 11:54:48 +0200
From: @joerivanruth
To: SQL devs <>
Version: 11.33.11 (Apr2019-SP1)
CC: @njnes

Last updated: 2019-11-28 10:00:05 +0100

Comment 27265

Date: 2019-09-06 11:54:48 +0200
From: @joerivanruth

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:69.0) Gecko/20100101 Firefox/69.0
Build Identifier:

Running the attached script crashes mserver5.
This happens on default, on Apr2019-SP1 and on Apr2019.
I bisected the problem, it starts occurring at commit

changeset: 68198:2c50b80d80c7
branch: Apr2019
user: Niels Nes niels@cwi.nl
date: Wed Jan 30 12:31:21 2019 +0100
summary: used patch from feature request Bug #6326, added cleanup of the

Reproducible: Always

Steps to Reproduce:

Run the attached demo.sh. Be careful, it kills all mserver5 processes and
rm -rf's $PWD/foo!

Actual Results:

mserver5: /home/jvr/monets/Apr2019_SP1/src/sql/backends/monet5/rel_bin.c:673: exp_bin: Assertion `s' failed.

Comment 27266

Date: 2019-09-06 11:56:18 +0200
From: @joerivanruth

Created attachment 628
reproducer script

Attached file: demo.sh (application/x-shellscript, 231 bytes)
Description: reproducer script

Comment 27267

Date: 2019-09-06 11:56:45 +0200
From: @joerivanruth

Created attachment 629
second part of reproducer script

Attached file: demo.sql (application/sql, 1153 bytes)
Description: second part of reproducer script

Comment 27268

Date: 2019-09-06 15:04:35 +0200
From: MonetDB Mercurial Repository <>

Changeset c110701164ef made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=c110701164ef

Changeset description:

Added test for bug #6755

Comment 27269

Date: 2019-09-07 14:59:57 +0200
From: MonetDB Mercurial Repository <>

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

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=48c24a608176

Changeset description:

make sure we keep the rank/project expression in all intermediate
relational operators (projections), solves bug #6755.