What happens?

I was surprised to find, while writing strange queries, that this one appeared to crash the engine:

SELECT * FROM (SELECT * FROM lineitem LIMIT 500) ORDER BY l_orderkey DESC LIMIT 10;

Of course this is a very strange way to write the query, but that was kind of the point---I wanted to see what the rowid pushdown / late materialization optimizers would do to it.

When I run this on the latest git main commit built with debugging symbols, I get:

INTERNAL Error:
Assertion triggered in file "/home/ryan/src/duckdb/src/optimizer/statistics/operator/propagate_get.cpp" on line 80: column_index < column_ids.size()

Stack Trace:

To Reproduce

LOAD tpch;
CALL dbgen(sf=0.1);
SELECT * FROM (SELECT * FROM lineitem LIMIT 500) ORDER BY l_orderkey DESC LIMIT 10;

OS:

Debian

DuckDB Version:

v1.4.0-dev899 (Development Version) 7b1a12c

DuckDB Client:

CLI

Hardware:

No response

Full Name:

Ryan Curtin

Affiliation:

Bauplan Labs

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

I have tested with a source build

Did you include all relevant data sets for reproducing the issue?

Not applicable - the reproduction does not require a data set

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