SELECT: no such binary operator 'sql_add(boolean,boolean)'

[monetdb-team]

Date: 2013-05-24 19:43:01 +0200
From: Peter <<Peter.DeRijk>>
To: SQL devs <>
Version: 11.15.7 (Feb2013-SP2)
CC: @njnes

Last updated: 2013-07-03 08:48:02 +0200

Comment 18748

Date: 2013-05-24 19:43:01 +0200
From: Peter <<Peter.DeRijk>>

The example code below gives the following error in the final select:
SELECT: no such binary operator 'sql_add(boolean,boolean)'
The query is supported by other databases and is (afaik) valid sql.

mclient -d monetdbtest -s 'drop table t' || true
mclient -d monetdbtest -s 'create table t ("v1" int,"v2" int, "v3" int)'
mclient -d monetdbtest -s 'insert into t ("v1","v2","v3") values (1,1,1)'
mclient -d monetdbtest -s 'insert into t ("v1","v2","v3") values (1,2,1)'
mclient -d monetdbtest -s 'insert into t ("v1","v2","v3") values (1,2,3)'
mclient -d monetdbtest -s 'insert into t ("v1","v2","v3") values (4,4,4)'
mclient -d monetdbtest -s 'select * from t where (("v1" > 1)+("v2" > 1)+("v3" > 1)) > 1'

Comment 18759

Date: 2013-05-31 19:32:20 +0200
From: MonetDB Mercurial Repository <>

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

Changeset description:

fixed bug #3289 and added test

Comment 18760

Date: 2013-05-31 19:33:35 +0200
From: @njnes

fixed bug by handling boolean add/sub