What happens?

The below test case triggers an INTERNAL error in DuckDB.

To Reproduce

CREATE  TABLE  t5(c0 INT, c2 DATE);
CREATE  TABLE  t0(c0 VARCHAR  );
CREATE VIEW v0 AS SELECT CAST(0 AS DATE) ;

SELECT * FROM t5, t0 LEFT JOIN  (SELECT c0)  ON true, v0 JOIN  (SELECT '' AS col1 FROM v0 WHERE (t5.c2 < CAST('' AS DATE))) AS sub1  ON true;
-- INTERNAL Error:
--Failed to bind column reference "c0" [1.0] (bindings: {#[2.0]})

OS:

Ubuntu 22.04

DuckDB Version:

v1.1.4-dev4060 f99785b

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?

Not applicable - the reproduction does not require a data set

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