Date: 2018-05-11 13:40:09 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.29.3 (Mar2018)
CC: @njnes

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

Comment 26441

Date: 2018-05-11 13:40:09 +0200
From: @PedroTadim

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

The query bellow produces wrong results in Mar2018 branch.

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER);
2. INSERT INTO tab2 VALUES(64,77,40),(75,67,58),(46,51,23);
3. SELECT * FROM tab2 WHERE + col2 NOT IN ( + - 59 + + ( 76 ), col1, + CAST ( NULL AS INTEGER ), col1, - 19, col1 );

Actual Results:

[ 64, 77, 40 ]
[ 75, 77, 40 ]
[ 46, 77, 40 ]

Expected Results:

An empty result set.

Comment 26442

Date: 2018-05-11 13:40:34 +0200
From: MonetDB Mercurial Repository <>

Changeset 265c2bacd276 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=265c2bacd276

Changeset description:

Added test for bug #6602

Comment 26451

Date: 2018-05-17 08:06:01 +0200
From: MonetDB Mercurial Repository <>

Changeset 1d3a15ef3aee 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=1d3a15ef3aee

Changeset description:

added stable output for bug #6602 (and correct for bugs 6530 and 6594)

Comment 26457

Date: 2018-05-20 23:16:59 +0200
From: MonetDB Mercurial Repository <>

Changeset 19f676b55173 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=19f676b55173

Changeset description:

fixes for bug #6602, ie make sure we handle null's in NOT in (left and right
side are handled in the rel2bin code now)