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
22117	Filtering on an annotation returns no reults in sqlite3 when it should return results.	dylan@…	Martin Matusiak	"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!                   

"	Bug	closed	Database layer (models, ORM)	dev	Normal	duplicate	nlsprint14	Martin Matusiak	Accepted	0	0	0	0	0	0