Skip to content

Unexpected result when using IS DISTINCT FROM with constants #7543

Description

@suyZhong

Describe the bug
Consider the following test cases. I suppose the first query is unexpected: it should return false but not null. The query with a NOT predicate could return the expected result.

To Reproduce

SELECT ((NULL NOT IN ('a')) IS NOT DISTINCT FROM true);
-- Expected: false
-- Actual: null

SELECT (NOT ((NULL NOT IN ('a')) IS NOT DISTINCT FROM true)); -- true

Expected behavior
As mentioned above.

Screenshots
N/A

Software versions
Build from source:

> docker exec -it monetdb-test mserver5 --version
MonetDB 5 server 11.52.0 (hg id: 53f9d56) (64-bit, 128-bit integers)
This is an unreleased version
Copyright (c) 1993 - July 2008 CWI
Copyright (c) August 2008 - 2023 MonetDB B.V., all rights reserved
Visit https://www.monetdb.org/ for further information
Found 503.5GiB available memory, 128 available cpu cores
Libraries:
Compiled by: @49c6d00b8d79 (x86_64-pc-linux-gnu)
Compilation: /usr/bin/cc 
Linking    : /usr/bin/ld

Issue labeling
Bug

Additional context
Add any other context about the problem here.

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions