Date: 2015-11-18 21:59:43 +0100
From: @yzchang
To: SQL devs <>
Version: 11.21.11 (Jul2015-SP1)
CC: @yzchang

Last updated: 2016-01-15 11:38:07 +0100

Comment 21554

Date: 2015-11-18 21:59:43 +0100
From: @yzchang

It seems that only the specific combination of the JOIN and WHERE conditions in the query below crashes mserver, because the crash doesn't happen when the conditions are slightly changed.

CREATE TABLE foo (startdate DATE, enddate DATE);
CREATE TABLE bar (id INTEGER);

SELECT COUNT(*)
FROM foo AS A
INNER JOIN foo AS B
ON (
(B.startdate = B.enddate
AND (B.startdate = A.startdate OR B.startdate = A.enddate)
) OR (
A.startdate < B.enddate AND A.enddate > B.startdate
)
)
WHERE EXISTS (
SELECT TRUE
FROM bar
WHERE A.startdate > '2010-10-01'
)
AND A.startdate >= B.startdate;

Comment 21555

Date: 2015-11-18 22:05:21 +0100
From: MonetDB Mercurial Repository <>

Changeset cf67ddd5966a made by Jennie Zhang y.zhang@cwi.nl in the MonetDB repo, refers to this bug.

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

Changeset description:

Added test for Bug #3872

Comment 21556

Date: 2015-11-18 22:08:58 +0100
From: @yzchang

This bug is fixed by Changeset: 07d638d6680a