Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Assertion Trigger on FULL OUTER JOIN with more than two BETWEEN clauses #6256

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant