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

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

Comment 25979

Date: 2017-12-11 12:10:15 +0100
From: @PedroTadim

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

In a select query with an IN clause, it seems that it is not possible to provide a table a column there.

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab0(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 TEXT, col3 INTEGER, col4 FLOAT, col5 TEXT);
2. SELECT ALL * FROM tab0 AS cor0 WHERE NOT CAST ( NULL AS INTEGER ) NOT IN ( col3 / col1 );

Actual Results:

Parse error: SELECT: identifier 'col3' unknown

Expected Results:

An empty result set.

Comment 25980

Date: 2017-12-11 12:15:35 +0100
From: MonetDB Mercurial Repository <>

Changeset 68357599b75f 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=68357599b75f

Changeset description:

Added test for Bug #6490

Comment 25986

Date: 2017-12-12 07:42:05 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

fix bug #6490, ie add missing 'in' function and handeling

Comment 25990

Date: 2017-12-12 11:01:59 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

Added queries related to bug #6490 still failing

Comment 26016

Date: 2017-12-16 12:00:50 +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)