Date: 2015-01-26 19:42:21 +0100
From: Anthony Damico <>
To: SQL devs <>
Version: 11.19.7 (Oct2014-SP1)
CC: @njnes

Last updated: 2015-05-07 12:38:02 +0200

Comment 20578

Date: 2015-01-26 19:42:21 +0100
From: Anthony Damico <>

User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:35.0) Gecko/20100101 Firefox/35.0
Build Identifier:

fully documented here

https://stackoverflow.com/questions/28120224/monetdb-or-clause?noredirect=1comment44677898_28120224

Reproducible: Always

Steps to Reproduce:

Welcome to mclient, the MonetDB/SQL interactive terminal (Jan2014-SP3)
Database: MonetDB v11.17.21 (Jan2014-SP3), 'demo'
Type \q to quit, ? for a list of available commands
auto commit mode: on
sql>
sql>
sql>CREATE TABLE employee
more>(
more> employee_id INTEGER NOT NULL,
more> manager_id INTEGER NULL
more>);
operation successful (38.382ms)
sql>
sql>INSERT INTO employee (employee_id,manager_id) values (50,70);
1 affected rows (18.525ms)
sql>INSERT INTO employee (employee_id,manager_id) values (60,70);
1 affected rows (1.100ms)
sql>INSERT INTO employee (employee_id,manager_id) values (70,null);
1 affected rows (1.083ms)
sql>
sql>select employee_id, manager_id
more>from employee
more>where employee_id = 60
more>and (manager_id in (-1) or -1 in (-1));
+-------------+------------+
| employee_id | manager_id |
+=============+============+
| 50 | 70 |
| 60 | 70 |
| 70 | null |
+-------------+------------+
3 tuples (1.628ms)
sql>

Actual Results:

all three lines

Expected Results:

i think it should just be the employee id == 60?

Comment 20583

Date: 2015-01-27 08:52:14 +0100
From: MonetDB Mercurial Repository <>

Changeset c106814afbd5 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=c106814afbd5

Changeset description:

fixed bug in in / or handling. Fixes bug #3655.

Comment 20584

Date: 2015-01-27 08:53:32 +0100
From: @njnes

fixed, the -1 in (-1) wasn't handled properly