Context Navigation

← Previous Ticket
Next Ticket →

#34717 closed Bug (fixed)

Cannot use aggregate over window functions since 4.2 — at Version 8

Reported by:	younes-chaoui	Owned by:	Simon Charette
Component:	Database layer (models, ORM)	Version:	4.2
Severity:	Release blocker	Keywords:	aggregation, window functions, psycopg
Cc:	Simon Charette	Triage Stage:	Ready for checkin
Has patch:	yes	Needs documentation:	no
Needs tests:	no	Patch needs improvement:	no
Easy pickings:	no	UI/UX:	no

Description (last modified by younes-chaoui)

After upgrading to Django 4.2, I encountered an exception when executing ORM queries that involve aggregates over Window functions. The specific error was psycopg2.errors.GroupingError: aggregate function calls cannot contain window function calls

Dependencies :

psycopg2 version: 2.9.3
django version: 4.2.3
PostgreSQL version: 13.4

Example Code:

queryset = queryset.annotate(
    cumul_DJR=Coalesce(Window(Sum("DJR"), order_by=F("date").asc()), 0.0)
)

aggregate = queryset.aggregate(
    DJR_total=Sum("DJR"),
    cumul_DJR_total=Sum("cumul_DJR")
)

Change History (8)

comment:1 by younes-chaoui, 16 months ago

Keywords:	aggregation window functions psycopg added
Type:	Uncategorized → Bug

comment:2 by Natalia Bidart, 16 months ago

Cc:	Simon Charette added
Resolution:	→ needsinfo
Status:	new → closed

Hello! Could you please provide a minimal Django test project with models to reproduce this issue? Or a regression test that would pass on Django 4.1 but fail in 4.2? Thank you!

comment:3 by Simon Charette, 16 months ago

Component:	Uncategorized → Database layer (models, ORM)
Has patch:	set
Resolution:	needsinfo
Severity:	Normal → Release blocker
Status:	closed → new
Triage Stage:	Unreviewed → Accepted