Sqlitelogictest: IN operator return a single column

[monetdb-team]

Date: 2018-01-25 10:57:04 +0100
From: @PedroTadim
To: SQL devs <>
Version: -- development
CC: @njnes

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

Comment 26116

Date: 2018-01-25 10:57:04 +0100
From: @PedroTadim

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

The IN operator is generating compilation errors in some queries. As the error says, the inner query should output a single column as an union of all expressions there.

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE tab2(col0 INTEGER, col1 INTEGER, col2 INTEGER);
2. INSERT INTO tab2 VALUES (64,77,40), (75,67,58), (46,51,23);
3. SELECT ALL * FROM tab2 WHERE + col0 IN ( - 12, col0, - col1, col1 / + col0, col1 );

Actual Results:

The error:
IN: inner query should return a single column

Expected Results:

The result set:

col0 | col1 | col2
------+------+------
64 | 77 | 40
75 | 67 | 58
46 | 51 | 23

Comment 26122

Date: 2018-01-25 13:34:49 +0100
From: MonetDB Mercurial Repository <>

Changeset 32dc8a911410 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=32dc8a911410

Changeset description:

Added tests for bugs 6522 and 6523

Comment 26132

Date: 2018-01-28 10:24:51 +0100
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixed bug #6522, ie handle constants before correlated in part