What happens? When using GROUP BY ALL, DuckDB incorrectly includes columns with window functions in the GROUP BY clause. This leads to a Binder Error: Cannot group on a window clause. To Reproduce ...

SQL window functions are calculation functions similar to aggregate functions but, unlike normal aggregate functions like “group by,” have access to individual rows and can even add some of ...