[Django] #36361: Grouping by date/datetime/time subfields then aggregating causes the sql compiler to explode

[Django]

#36361: Grouping by date/datetime/time subfields then aggregating causes the sql
compiler to explode
-------------------------------------+-------------------------------------
Reporter: Lily A. N. | Type: Bug
Status: new | Component: Database
| layer (models, ORM)
Version: 5.2 | Severity: Normal
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
example:

{{{
Foo.objects.values('date__year','val').annotate(total=models.Sum('val'))
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/36361>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#36361: Grouping by date/datetime/time subfields then aggregating causes the sql
compiler to explode
-------------------------------------+-------------------------------------

Reporter: Lily A. N. | Owner: (none)
Type: Bug | Status: closed
Component: Database layer | Version: 5.2
(models, ORM) |
Severity: Normal | Resolution: needsinfo

Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Simon Charette):

* resolution: => needsinfo
* status: new => closed

Comment:

Unfortunately it's impossible to know for sure with the low amount of
details your provided (lack of complete model definition, traceback, exact
version of Django you reproduced against) but I'm pretty sure this is
duplicate of #36292 (''Annotating an aggregate function over a group
including annotations or transforms followed by a column references
crashes with `IndexError`'') fixed by
543e17c4405dfdac4f18759fc78b190406d14239 in Django 5.2.1 meant to be
released on May 7th.
--
Ticket URL: <https://code.djangoproject.com/ticket/36361#comment:1>