duckdb: INTERNAL Error when using UNLIST

What happens?

Query throws an INTERNAL Error: Failed to bind column reference "r" [5.0] (bindings: [7.0]). Moreover, any query after that gives:

FATAL Error: Failed: database has been invalidated because of a previous fatal error. The database must be restarted prior to being used again.
Original error: "INTERNAL Error: Failed to bind column reference "r" [5.0] (bindings: [7.0])"

Happens in the latest master (tested with R client) and also in WASM shell.

Somewhat similar to #5660, but no visible GROUP BY ALL here.

To Reproduce

SELECT unlist(str_split('A',' ')) AS "r", CASE WHEN ("r" = 'A') THEN (-1) ELSE 0 END AS "x", sum("x") OVER () AS "s";
SELECT 1;

OS:

MacOS 10.15.7

DuckDB Version:

0.6.1

DuckDB Client:

Wasm shell, R

Full Name:

Reijo Sund

Affiliation:

University of Eastern Finland

Have you tried this on the latest master branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree