#25171: Can't update queryset after Count annotation
-------------------------------------+-------------------------------------
Reporter: fraserharris | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 1.6
(models, ORM) |
Severity: Normal | Resolution:
Keywords: queryset, update, | Triage Stage: Accepted
annotate, count |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by shaib):
For the query given in the report:
{{{
Category.objects.annotate(Count('tiles')).update(name='foo')
}}}
I would like to see a warning (if not an error) because the annotation is
"dead code" and probably a bug.
However, I'd expect this to work (assuming an additional numeric field
"score" on the Category model)
{{{
Category.objects.annotate(n_tiles=Count('tiles')).update(score=F('score')+F('n_tiles'))
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/25171#comment:4>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/070.ed7d7d269eeca134f2ab25e745364083%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
