Re: [Django] #35586: Aggregation optimization doesn't account for not referenced set-returning annotations on Postgres (was: Queryset count and length do not match when annotating using JSONB_PATH_QUERY)

[Django]

#35586: Aggregation optimization doesn't account for not referenced set-returning
annotations on Postgres
-------------------------------------+-------------------------------------
Reporter: devin13cox | Owner: (none)
Type: Bug | Status: new
Component: Database layer | Version: 5.0
(models, ORM) |
Severity: Normal | Resolution:
Keywords: postgres, set- | Triage Stage: Accepted
returning, aggregation, |
annotation |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Simon Charette):

* keywords: => postgres, set-returning, aggregation, annotation
* summary:
Queryset count and length do not match when annotating using
JSONB_PATH_QUERY
=>
Aggregation optimization doesn't account for not referenced set-
returning annotations on Postgres

--
Ticket URL: <https://code.djangoproject.com/ticket/35586#comment:4>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.