What happens?

In a alter column using with a lambda, a reference to a lambda bound variable is attempted to be resolved as column reference.

To Reproduce

CREATE TABLE Cities AS SELECT * FROM (VALUES ('Amsterdam', [90,10]), ('London', [89,102])) Cities(Name, Prices);

ALTER TABLE Cities ADD COLUMN LowPrices INTEGER[];

ALTER TABLE Cities
ALTER COLUMN LowPrices SET DATA TYPE INTEGER[] USING 
list_filter(Cities.Prices, price -> price<100);

Binder Error: Table does not contain column price referenced in alter statement!

OS:

osx arm64

DuckDB Version:

0.10.2-dev311

DuckDB Client:

Python

Full Name:

eaubin

Affiliation:

NA

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

I have tested with a nightly 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