#33768: MySQL ordering of nulls last/first is broken in combination with UNION -------------------------------------+------------------------------------- Reporter: Florian Apolloner | Owner: Simon | Charette Type: Bug | Status: closed Component: Database layer | Version: dev (models, ORM) | Severity: Normal | Resolution: fixed Keywords: | Triage Stage: Ready for | checkin Has patch: 1 | Needs documentation: 0 Needs tests: 0 | Patch needs improvement: 0 Easy pickings: 0 | UI/UX: 0 -------------------------------------+------------------------------------- Changes (by Mariusz Felisiak <felisiak.mariusz@…>):
* status: assigned => closed * resolution: => fixed Comment: In [changeset:"c58a8acd413ccc992dd30afd98ed900897e1f719" c58a8acd]: {{{ #!CommitTicketReference repository="" revision="c58a8acd413ccc992dd30afd98ed900897e1f719" Fixed #33768 -- Fixed ordering compound queries by nulls_first/nulls_last on MySQL. Columns of the left outer most select statement in a combined query can be referenced by alias just like by index. This removes combined query ordering by column index and avoids an unnecessary usage of RawSQL which causes issues for backends that specialize the treatment of null ordering. }}} -- Ticket URL: <https://code.djangoproject.com/ticket/33768#comment:10> 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 on the web visit https://groups.google.com/d/msgid/django-updates/01070183a81fc37b-2e789cf1-f902-40e1-a19d-64047c42cfe2-000000%40eu-central-1.amazonses.com.