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@…		"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

---"		reopened	Documentation	dev					Accepted	0	0	0	0