Date: 2020-06-16 18:33:01 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)

Last updated: 2020-07-27 09:30:15 +0200

Comment 27861

Date: 2020-06-16 18:33:01 +0200
From: @PedroTadim

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

Run the queries bellow.

Reproducible: Always

Steps to Reproduce:

CREATE TABLE "sys"."t0" ("c0" INTEGER,"c1" DOUBLE);
COPY 15 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
-1498252621 -1498252621
0 NULL
-539579569 -539579569
-108613919 NULL
0 0
8 NULL
1783007739 NULL
498706403 NULL
0 0.6103170716911988
1493854316 0.6198781779645515
-1608947797 1
1 0.8356779050811012
-101868623 0.16442926747225173
1493854316 -1498252621
1 0.9401903184230552

SELECT t0.c0 FROM t0 WHERE ((0.9952398693354088) IN (t0.c1, t0.c1)) IS NULL;

Actual Results:

0
-539579569
0
8
1783007739

Expected Results:

0
-108613919
8
1783007739
498706403

Comment 27862

Date: 2020-06-17 11:03:54 +0200
From: MonetDB Mercurial Repository <>

Changeset 8b7b7e2b98e8 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=8b7b7e2b98e8

Changeset description:

Bug #6905 was fixed by recent changes