What happens?

An internal error is thrown in a select query.

Test case generated with SQLancer.

To Reproduce

CREATE TABLE t0(c0 BOOLEAN, PRIMARY KEY(c0));
CREATE TABLE t63(c0 VARCHAR COLLATE C, PRIMARY KEY(c0));
insert into t0(c0) values (0.7);
insert into t63(c0) values ('1');
SELECT t63.c0 FROM t0 NATURAL LEFT JOIN t63;

OS:

Arch Linux x86_64

DuckDB Version:

v1.1.0 fa5c2fe

DuckDB Client:

duckdb cli

Hardware:

No response

Full Name:

Ming Wei Tan

Affiliation:

National University of Singapore

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

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