Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Exist operator on type bigint missing (sqlsmith) #6315

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

Exist operator on type bigint missing (sqlsmith) #6315

monetdb-team opened this issue Nov 30, 2020 · 0 comments

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant