Cannot use correlated column name in FROM clause of LATERAL join

[soerenwolfers]

What happens?

Cannot use correlated column name in FROM clause of LATERAL join. This might not be a bug (although it does differ from POSTGRESQL), but I'd still be interested whether something like this is possible.

In practice, rather than a range, I'd be calling read_parquet.

To Reproduce

SELECT *
FROM (
    SELECT 1
) tb(i), 
LATERAL (
    SELECT * FROM range(tb.i)
)

BinderException: Binder Error: No function matches the given name and argument types 'range(VARCHAR)'.

(an attempted cast to integer reveals that tb.i is treated like a string literal)
In POSTGRESQL, the following works:

SELECT * FROM (VALUES (1), (2)) tb1(i)
LEFT JOIN LATERAL
(
  SELECT * FROM generate_series(1, tb1.i)
) tb2(j)
ON true;

i	j
1	1
2	1
2	2

View on DB Fiddle

OS:

Linux

DuckDB Version:

0.10.1

DuckDB Client:

Python

Full Name:

Soeren Wolfers

Affiliation:

G-Research

Have you tried this on the latest nightly build?

I have tested with a nightly build

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

• Yes, I have

[kryonix]

This is related to #7522, #5762, and #6917. The issue here is that neither range nor generate_series are table in-out functions. Same is true for read_parquet, apparently. Therefore the functions cannot take the columns of the lateral join as input parameters.

[soerenwolfers]

Clear error message added at #11436 -- prioritization of actual fix up to maintainers and doesn't require this ticket.