Date: 2018-02-01 10:56:01 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-05-17 08:06:02 +0200

Comment 26156

Date: 2018-02-01 10:56:01 +0100
From: @PedroTadim

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

The select query bellow with the NOT IN operator is giving wrong results:

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab0(col0 INTEGER, col1 INTEGER, col2 INTEGER);
2. INSERT INTO tab0 VALUES (97,1,99), (15,81,47), (87,21,10);
3. SELECT ALL - ( - COUNT ( * ) ) FROM tab0 AS cor0 WHERE col0 / ( - + col2 ) NOT IN ( + + col0, + col0 * + ( col1 ), + ( + - col0 ) * - 45, + CAST ( NULL AS INTEGER ) );

Actual Results:

3

Comment 26158

Date: 2018-02-01 10:59:20 +0100
From: MonetDB Mercurial Repository <>

Changeset 165307be5363 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=165307be5363

Changeset description:

Added tests for bugs 6529 and 6530

Comment 26217

Date: 2018-02-18 16:17:38 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixes for bug #6529 and 6530, ie do not set the tnonil flag (nil in gives nil hash values).

Comment 26312

Date: 2018-03-29 15:39:14 +0200
From: @sjoerdmullender

The Mar2018 version has been released.

Comment 26452

Date: 2018-05-17 08:06:02 +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)