apache / apache/arrow

[C++] Support IS DISTINCT and IS NOT DISTINCT expression.

Open
#37,320 1 comment 0 reactions 1 assignee Claimed by @Light-City View on GitHub
Component: C++ Type: enhancement
Dominant language
C++
Stars
17.1k
Forks
4.3k
Avg merge
3d 13h
Merged PRs (30d)
88

Description

### Describe the enhancement requested

Ordinary comparison operators yield null (signifying “unknown”), not true or false, when either input is null. For example, 7 = NULL yields null, as does 7 <> NULL. When this behavior is not suitable, use the IS [ NOT ] DISTINCT FROM predicates:

a IS DISTINCT FROM b
a IS NOT DISTINCT FROM b

usage:

```
select * from test where a is distinct from b;
```

or

```
select * from test where a is not distinct from b;
```

reference: https://www.postgresql.org/docs/current/functions-comparison.html

### Component(s)

C++

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.