#17389: Filtering by forkeign keys add unnecessary table joins
-------------------------------------+-------------------------------------
Reporter: TwelveSixty | Owner: nobody
Type: Bug | Status: closed
Component: Database layer | Version: 1.3
(models, ORM) | Resolution: invalid
Severity: Normal | Triage Stage:
Keywords: | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by akaariai):
The double NOT is what you get in the current ORM implementation. I assume
you get WHERE NOT (fk_id IS NOT NULL). Correcting this is not trivial, but
I think there is some interest in the community to fix this.
As I haven't actually tested anything, and I think this is a known
problem, I will leave this as closed.
--
Ticket URL: <https://code.djangoproject.com/ticket/17389#comment:3>
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 post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
