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
19493	annotate(Count()) does not work properly with django.db.backends.oracle	kimvais@…	nobody	"An QuerySet operation like:
models.SomeModel.objects.filter(somecharfield=value).values(""someintegerfield"").annotate(Count(""someintegerfield"")) 

return a QuerySet with no aggregate count, but multiple rows with `someintegerfield__count=1`

The correct SQL would be:
{{{
SELECT tablespace_somemodel.someintegerfield, COUNT(tablespace_somemodel.someintegerfield) AS someintegerfield__count
  FROM tablespace_somemodel WHERE tablespace_somemodel.somecharfield = 'value'
 GROUP BY tablespace_somemodel.someintegerfield;
}}}

This works fine on other backends."	Uncategorized	new	Database layer (models, ORM)	1.4	Normal		oracle		Unreviewed	0	0	0	0	0	0