Table function "read_csv" does not support lateral join column parameters

[debackerl]

What happens?

After upgrading from 0.10.1 to 0.10.2, I get the error "Table function "read_csv" does not support lateral join column parameters".

To Reproduce

The error comes from the second statement below. I have simplified it as much as possible.

db.execute("""--sql
CREATE OR REPLACE VIEW actions AS
SELECT *
FROM read_csv('nasdaq-data-link/SHARADAR/ACTIONS-2024-04-23.csv.zst', columns={'date': date, 'action': varchar, 'ticker': varchar, 'name': varchar, 'value': varchar, 'contraticker': varchar, 'contraname': varchar}, header=true, dateformat='%Y-%m-%d')
""")

db.execute("""--sql
CREATE OR REPLACE VIEW symbolchanges AS
SELECT *
FROM actions f
INNER JOIN actions t ON f.ticker = t.ticker
""")

OS:

Linux PopOS x64

DuckDB Version:

0.10.2 (via pip)

DuckDB Client:

Python 3.11.7

Full Name:

Laurent Debacker

Affiliation:

Personal research

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?

No - I cannot share the data sets because they are confidential

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

[duckdblabs-bot]

Thanks for opening this issue! Based on our automated check, it seems that your post contains some code but it does not use code blocks to format it.

Please double-check your post and revise it if necessary. To employ syntax highlighting, it's recommended to use code blocks with triple backticks, e.g.:

```sql
SELECT ...
```

If this is a false positive, feel free to disregard this comment.

[Mytherin]

Thanks for the report! I've pushed a fix in #11825.

Using string literals as input to columns would also resolve this issue, e.g.:

CREATE OR REPLACE VIEW actions AS
SELECT *
FROM read_csv('nasdaq-data-link/SHARADAR/ACTIONS-2024-04-23.csv.zst', columns={'date': 'date', 'action': 'varchar', 'ticker': 'varchar', 'name': 'varchar', 'value': 'varchar', 'contraticker': 'varchar', 'contraname': 'varchar'}, header=true, dateformat='%Y-%m-%d')