[Django] #24039: Filtering using __in on a count annotated queryset returns empty results

[Django]

#24039: Filtering using __in on a count annotated queryset returns empty results
-------------------------------+--------------------
Reporter: dustinfarris | Owner: nobody
Type: Bug | Status: new
Component: Uncategorized | Version: 1.7
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------+--------------------
See failing tests and description in PR
[https://github.com/django/django/pull/3773]

Also see example output from pdb in my own project here:
http://dpaste.com/3JQYWTZ#line-31

--
Ticket URL: <https://code.djangoproject.com/ticket/24039>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#24039: Filtering using __in on a count annotated queryset returns empty results

-------------------------------+--------------------------------------

Reporter: dustinfarris | Owner: nobody
Type: Bug | Status: new
Component: Uncategorized | Version: 1.7

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

-------------------------------+--------------------------------------
Changes (by dustinfarris):

* needs_better_patch: => 0
* needs_tests: => 0
* needs_docs: => 0

Old description:

> See failing tests and description in PR
> [https://github.com/django/django/pull/3773]
>
> Also see example output from pdb in my own project here:
> http://dpaste.com/3JQYWTZ#line-31

New description:

See failing tests and description in GitHub PR
https://github.com/django/django/pull/3773

Also see example output from pdb in my own project here:
http://dpaste.com/3JQYWTZ#line-31

--

--
Ticket URL: <https://code.djangoproject.com/ticket/24039#comment:1>

[Django]

#24039: Filtering using __in on a count annotated queryset returns empty results

-------------------------------------+-------------------------------------
Reporter: dustinfarris | Owner: nobody
Type: | Status: new
Cleanup/optimization |
Component: Database layer | Version: 1.7
(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 timgraham):

* component: Uncategorized => Database layer (models, ORM)
* type: Bug => Cleanup/optimization
* stage: Unreviewed => Accepted

Comment:

I am not sure this can be fixed (or if it should be) as there are subtle
differences depending on where you use `filter()` on a QuerySet but at
least the documentation could probably be improved.

--
Ticket URL: <https://code.djangoproject.com/ticket/24039#comment:2>