Date: 2018-03-25 20:00:35 +0200
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-06-20 11:02:10 +0200

Comment 26291

Date: 2018-03-25 20:00:35 +0200
From: @PedroTadim

User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36
Build Identifier:

Run the query below for an assertion error in rel_bin.c

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER);
2. INSERT INTO tab1 VALUES(22,6,8), (28,57,45), (82,44,71);
3. SELECT - + 48 * COUNT ( * ) FROM tab1 AS cor0 GROUP BY col2, col2, col0 HAVING NOT NULL NOT IN ( - + col2, COUNT ( * ), col2 / + 30 + + COUNT ( * ), - 19 );

Actual Results:

Assertion error in rel_bin.c

Expected Results:

An empty result set

No backtrace needed :)

Comment 26292

Date: 2018-03-25 20:01:10 +0200
From: MonetDB Mercurial Repository <>

Changeset 7e482660d6ee 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=7e482660d6ee

Changeset description:

Added test for Bug #6562

Comment 26294

Date: 2018-03-28 11:23:27 +0200
From: MonetDB Mercurial Repository <>

Changeset be9ea021c85d 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=be9ea021c85d

Changeset description:

fixed bug #6562, ie only add expressions in the selection phase