#28900: QuerySet.values() and values_list() for compound queries fails with annotation. -------------------------------------+------------------------------------- Reporter: elliott-omosheye | Owner: Simon | Charette Type: Bug | Status: closed Component: Database layer | Version: 1.11 (models, ORM) | Severity: Normal | Resolution: fixed Keywords: union, values | Triage Stage: Ready for | checkin Has patch: 1 | Needs documentation: 0 Needs tests: 0 | Patch needs improvement: 0 Easy pickings: 0 | UI/UX: 0 -------------------------------------+------------------------------------- Comment (by Sarah Boyce <42296566+sarahboyce@…>):
In [changeset:"7f6a5fbe2ef26d9970508d5a7236fe009ec274d0" 7f6a5fbe]: {{{#!CommitTicketReference repository="" revision="7f6a5fbe2ef26d9970508d5a7236fe009ec274d0" [5.2.x] Fixed #36360 -- Fixed QuerySet.update() crash when referring annotations through values(). The issue was only manifesting itself when also filtering againt a related model as that forces the usage of a subquery because SQLUpdateCompiler doesn't support the UPDATE FROM syntax yet. Regression in 65ad4ade74dc9208b9d686a451cd6045df0c9c3a. Refs #28900. Thanks Gav O'Connor for the detailed report. Backport of 8ef4e0bd423ac3764004c73c3d1098e7a51a2945 from main. }}} -- Ticket URL: <https://code.djangoproject.com/ticket/28900#comment:34> 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 view this discussion visit https://groups.google.com/d/msgid/django-updates/0107019686115cd3-d406fab5-0cd4-4f38-b114-b00eb44f9dde-000000%40eu-central-1.amazonses.com.