#29315: exclude with OneToOneField produces incorrect results on sqlite
-------------------------------------+-------------------------------------
Reporter: Raphael Kimmig | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 2.0
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Raphael Kimmig):
I just tried reproducing the bug on Debian 9 and I can't.
I'm running mac os 10.12.6 on the affected machine.
The query produced looks fine:
{{{
SELECT "bar_a"."id" FROM "bar_a" LEFT OUTER JOIN "bar_b" ON ("bar_a"."id"
= "bar_b"."a_id") WHERE NOT ("bar_b"."value" = 12345 AND "bar_b"."value"
IS NOT NULL) LIMIT 21
}}}
sqlite version on the affected mac:
{{{
sqlite3.version
>>> '2.6.0'
sqlite3.sqlite_version
>>> '3.23.0'
}}}
Is there anything else that might be helpful?
--
Ticket URL: <https://code.djangoproject.com/ticket/29315#comment:2>
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 post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/071.99cbe3c210c4fac014a7891291328958%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
