Date: 2017-04-06 11:22:04 +0200
From: Mark <<m.raasveldt>>
To: SQL devs <>
Version: 11.25.15 (Dec2016-SP3)
CC: @njnes

Last updated: 2017-05-01 13:44:59 +0200

Comment 25197

Date: 2017-04-06 11:22:04 +0200
From: Mark <<m.raasveldt>>

When performing a FULL OUTER JOIN with three or more BETWEEN clauses OR'd together an assertion is triggered in the SQL layer:

Assertion failed: (0), function exp_bin, file rel_bin.c, line 690.

Code to reproduce:

START TRANSACTION;

CREATE TABLE t1(x INTEGER, y INTEGER);
CREATE TABLE t2(a INTEGER, b INTEGER);

-- this works fine

SELECT *
FROM
t1
FULL OUTER JOIN
t2
ON
x BETWEEN a AND b OR
y BETWEEN a AND b;

-- this triggers an assertion
SELECT *
FROM
t1
FULL OUTER JOIN
t2
ON
x BETWEEN a AND b OR
y BETWEEN a AND b OR
a BETWEEN x AND y;

ROLLBACK;

Comment 25198

Date: 2017-04-06 11:25:31 +0200
From: MonetDB Mercurial Repository <>

Changeset 064c92514664 made by Mark Raasveldt m.raasveldt@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

Add test for Bug #6256.

Comment 25207

Date: 2017-04-08 14:02:30 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixed crash in full outer joins with only range expressions (or-ed together). see bug #6256