What happens?

DuckDB internal error happens when "is not distinct from" is combined with or. This seems to be a regression in 1.2, still present in 1.2.1. Error does not happen in 1.1.3.

Can be reproduced in cli, or in client APIs, or in shell.duckdb.org.

Output from cli:

v1.2.1 8e52ec4395
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.

create table test as select 'tst' as tst;
select * from test where tst is not distinct from 'a' or tst is not distinct from 'b';

INTERNAL Error:
Expression type not implemented for string statistics zone map
This error signals an assertion failure within DuckDB. This usually occurs due to unexpected conditions or errors in the program's logic.
For more information, see https://duckdb.org/docs/dev/internal_errors

To Reproduce

create table test as select 'tst' as tst; 
select * from test where tst is not distinct from 'a' or tst is not distinct from 'b';

OS:

Win10 x86_64

DuckDB Version:

1.2.1 and v1.3.0-dev1204

DuckDB Client:

all

Hardware:

No response

Full Name:

Heikki Innanen

Affiliation:

Metabees Oy

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

I have tested with a stable release (1.2.1) and v1.3.0-dev1204

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