#29932: Queryset `difference()` after `intersection()` returns wrong queryset on
SQLite
-------------------------------------+-------------------------------------
Reporter: michaeldel | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 2.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: queryset sqlite | Triage Stage:
difference intersection | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Description changed by michaeldel:
Old description:
> Considering a simple model
> {{{
> #!python
> from django.db import models
>
> class Foo(models.Model):
> pass
> }}}
>
> Here is the minimal way to encounter this issue
> {{{
> #!python
> Foo.objects.create(pk=1)
> Foo.objects.create(pk=2)
>
> a = Foo.objects.all()
> b = Foo.objects.intersection(Foo.objects.filter(pk=1))
>
> assert a.count() == 2
> assert b.count() == 1
>
> diff = a.difference(b)
>
> assert diff.exists() == 1 # fails with SQLite!
> }}}
> This operation however works as expected on PostgreSQL.
New description:
Considering a simple model
{{{
#!python
from django.db import models
class Foo(models.Model):
pass
}}}
Here is the minimal way to encounter this issue
{{{
#!python
Foo.objects.create(pk=1)
Foo.objects.create(pk=2)
a = Foo.objects.all()
b = Foo.objects.intersection(Foo.objects.filter(pk=1))
assert a.count() == 2
assert b.count() == 1
diff = a.difference(b)
assert diff.exists() # fails with SQLite!
}}}
This operation however works as expected on PostgreSQL.
--
--
Ticket URL: <https://code.djangoproject.com/ticket/29932#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/068.aa3ccba12a2646117ac1356dfec219b0%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
