You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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'
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:
Comment 18760
Date: 2013-05-31 19:33:35 +0200
From: @njnes
fixed bug by handling boolean add/sub
The text was updated successfully, but these errors were encountered: