#22117: Filtering on an annotation returns no reults in sqlite3 when it should
return results.
----------------------------------------------+--------------------
Reporter: dylan@… | Owner: nobody
Type: Bug | Status: new
Component: Database layer (models, ORM) | Version: 1.6
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
----------------------------------------------+--------------------
Creating an annotation which sums through a many to many field, then
filtering on that annotation produces no results when results are
expected. I have attached a sample app with a test case which reproduces
the bug, as well as a test case proving that the raw sql produced by the
queryset indeed returns results.
To repro:
unzip repro.zip
python manage.py test repro.thing
look at repro/thing/tests.py for the code
found on: Ubuntu 12.04.4
django version: 1.6.1
pysqlite version: 2.6.0
libsqlite3-0 version: 3.7.9-2ubuntu1.1
Let me know if I can help!
--
Ticket URL: <https://code.djangoproject.com/ticket/22117>
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 post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/064.8d8d948ab047af3c360489d10bac71a2%40djangoproject.com.
For more options, visit https://groups.google.com/groups/opt_out.
