INTERNAL Error: ConstantFilter constant cannot be NULL - use IsNullFilter instead

[suyZhong]

What happens?

The below test case triggered an internal error in DuckDB.

To Reproduce

CREATE TABLE  t0(c1 INT);
SELECT * FROM t0 WHERE ((t0.c1 IS DISTINCT FROM NULL) OR (NOT NULL));

OS:

Ubuntu 22.04

DuckDB Version:

v1.1.4-dev3741 ab8c909

DuckDB Client:

CLI

Hardware:

No response

Full Name:

Suyang Zhong

Affiliation:

NUS

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have tested with a source build

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

• Yes, I have