Date: 2017-05-13 22:47:03 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.25.21 (Dec2016-SP4)
CC: @njnes

Last updated: 2017-06-12 15:14:41 +0200

Comment 25317

Date: 2017-05-13 22:47:03 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:53.0) Gecko/20100101 Firefox/53.0
Build Identifier:

The implementation of EXIST is incomplete

Reproducible: Always

Steps to Reproduce:

select
case when EXISTS ( select hashes from sys.tablestoragemodel )
then (true)
else (false)
end
from sys.tables;

Comment 25319

Date: 2017-05-13 23:16:16 +0200
From: @mlkersten

Also reported on this query

insert into sys.privileges values (
1,
31,
87,
case when EXISTS (
select
(select io from sys.querylog_calls)
as c0
from
sys.rejects as ref_0
where ref_0.fldid is NULL) then 56 else 56 end
,
case when (select dependency_type_name from sys.dependency_types)
is not NULL then 7 else 7 end
)

ERROR = !exist operator on type int missing

Comment 25322

Date: 2017-05-14 21:53:18 +0200
From: MonetDB Mercurial Repository <>

Changeset 2a80648779e3 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=2a80648779e3

Changeset description:

fix bug #6315, ie add missing exists functions.

Comment 25324

Date: 2017-05-14 21:55:56 +0200
From: @njnes

fixed in Dec2016. added missing exists functions