id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
10045	Improve documentation of .annotate() / .filter() ordering quirks	alex@…	Tim Graham <timograham@…>	"The documentation surrounding the ordering of .annotate() and .filter() clauses needs improvement. The current documentation is confusing (and arguably incorrect), leading to invalid bug reports like the following: 

---

I get something that looks like a missing join condition when doing 

{{{ModelA.objects.all().annotate(num_b=Count('modelb')).filter(modelb__somebool=True)[0].num_b}}}

I get {{{num_b = 2^i}}} for i objects of ModelB instead of {{{num_b=i}}} as I would expect to. 
Please see attached models.py file for the Model definition and test case.

django revision: 9756

---"	Cleanup/optimization	closed	Documentation	dev	Normal	fixed			Accepted	1	0	0	0	0	0