Date: 2018-05-10 20:31:12 +0200
From: @kutsurak
To: SQL devs <>
Version: 11.29.3 (Mar2018)
CC: marcell.bernat, @njnes

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

Comment 26433

Date: 2018-05-10 20:31:12 +0200
From: @kutsurak

User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:59.0) Gecko/20100101 Firefox/59.0
Build Identifier:

Consider the query

(1) SELECT * FROM tbl WHERE name IS NULL

When tbl is a remote table query (1) produces the correct results, but the next query, say

(2) SELECT * FROM tbl

returns the same result as query (1).

Reproducible: Always

Steps to Reproduce:

1. Create a remote table mirroring a base table that contains null values
2. SELECT * FROM tbl WHERE name IS NULL
3. SELECT * FROM tbl

Comment 26434

Date: 2018-05-10 20:39:18 +0200
From: MonetDB Mercurial Repository <>

Changeset 5dc1a714f475 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=5dc1a714f475

Changeset description:

Add test for Bug #6601

Comment 26437

Date: 2018-05-11 13:12:49 +0200
From: MonetDB Mercurial Repository <>

Changeset 99b2bffa6931 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=99b2bffa6931

Changeset description:

fixed bug #6601

Comment 26438

Date: 2018-05-11 13:13:38 +0200
From: @njnes

fixed (ie made remote queries (names) unique)