What happens?

Combining lateral joins with window functions leads to a crash

To Reproduce

Example file: https://github.com/malloydata/malloy/blob/ltabb/index-with-stages/test/data/duckdb/ga_sample.parquet

SELECT
       hits_0
    FROM  'ga_sample.parquet' ga_sessions
    , (SELECT
      row_number() over() as __row_id,
      x.access
      FROM
        (SELECT UNNEST(ga_sessions.hits)) as x(access)
    ) as hits_0
  GROUP BY 1

Without the window function the query behaves as expected:

  SELECT
       hits_0
    FROM  'ga_sample.parquet' ga_sessions
    , (SELECT
      x.access
      FROM
        (SELECT UNNEST(ga_sessions.hits)) as x(access)
    ) as hits_0
  GROUP BY 1

OS:

MacOS

DuckDB Version:

master

DuckDB Client:

CLI

Full Name:

Mark Raasveldt

Affiliation:

DuckDB Labs

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