Date: 2018-05-21 18:07:38 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.29.3 (Mar2018)
CC: @kutsurak, @njnes

Last updated: 2019-09-10 20:18:26 +0200

Comment 26459

Date: 2018-05-21 18:07:38 +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:

Run the queries bellow for wrong results. The NOT IN operator doesn't handle null values properly.

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 * FROM tab0 cor0 WHERE + col2 + + + 89 + - CAST ( NULL AS REAL ) NOT IN ( 28 * + 37 - ( + col1 ) + + 63, 4, ( ( + - col0 ) ), + col2 );

Actual Results:

+------+------+------+
| col0 | col1 | col2 |
+======+======+======+
| 97 | 1 | 99 |
| 15 | 81 | 47 |
| 87 | 21 | 10 |
+------+------+------+

Expected Results:

An empty result set.

I added other similar queries in the test file, which all of them should return an empty result set. I'm sure that all of them are related.

Comment 26460

Date: 2018-05-21 18:15:10 +0200
From: MonetDB Mercurial Repository <>

Changeset 170e20019960 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=170e20019960

Changeset description:

Added test for Bug #6605

Comment 26463

Date: 2018-05-23 09:52:39 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

partial fixes for bug #6605, ie handle again NULLs on the left side.

Comment 26464

Date: 2018-05-23 09:53:46 +0200
From: @njnes

nan == nan -> 0 ie the current BATselect(nil, true,true,false) fails.

Comment 26469

Date: 2018-05-30 11:13:21 +0200
From: MonetDB Mercurial Repository <>

Changeset 437ba3315182 made by Panagiotis Koutsourakis kutsurak@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=437ba3315182

Changeset description:

Bug #6605 has not been fixed in Mar2018

Comment 26999

Date: 2019-05-06 11:22:27 +0200
From: MonetDB Mercurial Repository <>

Changeset 49fdc1899528 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=49fdc1899528

Changeset description:

Adding more sqlite tests failing queries:

Bug #6605 outputs only 3 columns out of 6 on default.
Bug #6566 crashes on both Apr2019 and default.
Bug #6579 crashes on default.

Comment 27003

Date: 2019-05-08 13:04:32 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fix for problem with in without subquery (new output of bug #6605)

Comment 27274

Date: 2019-09-10 20:18:26 +0200
From: MonetDB Mercurial Repository <>

Changeset 890a6d8e9e25 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=890a6d8e9e25

Changeset description:

fix new crash in sqlitelogictest-cast-null-not-in.Bug-6605 (ie bug #6605)