#31285: Inherited model doesn't correctly order by "-pk" when specified on
Parent.Meta.ordering
-------------------------------------+-------------------------------------
Reporter: Jon Dufresne | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Simon Charette):
* stage: Unreviewed => Accepted
Comment:
Interesting `ordering` is effectively one of the rare `Meta`
[https://docs.djangoproject.com/en/3.0/topics/db/models/#meta-and-multi-
table-inheritance attribute preserved during MTI inheritance].
I also wonder if `ordering = ('pk',)` should be special cased to order by
the ''local'' child class primary key which would be
`"myapp_child"."parent_ptr_id"` in this case since it should result in the
same resulset because of foreign key integrity and avoid an unnecessary
`JOIN` in the cases where no parent fields are involved.
--
Ticket URL: <https://code.djangoproject.com/ticket/31285#comment:1>
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/067.b2381ab102ac6c065cb5334b97973988%40djangoproject.com.
