ORDER BY is not implemented for window functions

[manticore-projects]

What happens?

ORDER BY is not implemented for window functions

To Reproduce

-- fails: ORDER BY is not implemented for window functions!
select listagg(id ) 
within group (order by id)
over() from (select UNNEST([3,2,1]) AS id);

-- fails: ORDER BY is not implemented for window functions!
select listagg(id order by id) 
over() from (select UNNEST([3,2,1]) AS id);

-- works and produces the correct order
select listagg(id) 
over() from (select UNNEST([3,2,1]) AS id order by id);

OS:

Linux

DuckDB Version:

10.0.2

DuckDB Client:

Java

Full Name:

Andreas Reichel

Affiliation:

manticore-projects.com

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?

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

[soerenwolfers]

See #10966

But for your particular examples just put the ORDER BY clause in the window definition and use Rows between unbounded preceding and unbounded following, see https://duckdb.org/docs/sql/window_functions.html

[hawkfish]

This is a feature request, and we have the underlying algorithms in place, but it will be post v1.0 before I get to it. Also, it is behind a memory usage rewrite that is in process.