Date: 2017-12-11 15:54:04 +0100
From: @joerivanruth
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2018-02-12 16:12:07 +0100

Comment 25981

Date: 2017-12-11 15:54:04 +0100
From: @joerivanruth

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:58.0) Gecko/20100101 Firefox/58.0
Build Identifier:

This happens on the Jul2017_SP3 release candidate and also on default.

Reproducible: Always

Steps to Reproduce:

CREATE TABLE t(i INT);
INSERT INTO t VALUES (1), (2), (3);

SELECT 1 IN (SELECT i FROM t);
-- expect true

SELECT 4 IN (SELECT i FROM t);
-- expect false, got null

Actual Results:

+-------+
| L5 |
+=======+
| true |
+-------+

+-------+
| L5 |
+=======+
| null |
+-------+

Expected Results:

+-------+
| L5 |
+=======+
| true |
+-------+

+-------+
| L5 |
+=======+
| false |
+-------+

Comment 26017

Date: 2017-12-16 12:00:51 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixes for bug #6491 (select returns null)
	  bug #6497 (incorrect not between)
 	  bug #6490 (handle multiple columns in in in selection)

fixed type checking, allowed more equal types (int with 17 bits equals one with 31 etc)