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
10132	Aggregations add extra values to ValuesQuerySets	Glenn Maynard		"From http://groups.google.com/group/django-users/browse_frm/thread/15b3c24dddd2a2d5/2214eba4328126ca
{{{
#!python
Item.objects.extra(select={""note_alias"": ""note""}).values(""note_alias"").annotate(Count(""id"")).order_by('note_id')
}}}
generates:
{{{
#!sql
SELECT (note_id) AS ""note_alias"", U0.""id"", 
COUNT(""queries_item"".""id"") AS ""id__count"" FROM ""queries_item"" U0 
GROUP BY ""queries_item"".""id"", ""queries_item"".""name"", 
""queries_item"".""created"", ""queries_item"".""modified"", 
""queries_item"".""creator_id"", ""queries_item"".""note_id""
}}}

but should (possibly) generate:
{{{
#!sql
SELECT (note_id) AS ""note_alias"",
COUNT(""queries_item"".""id"") AS ""id__count"" FROM queries_item
 GROUP BY note_alias ORDER BY note_id
}}}
"		closed	Database layer (models, ORM)	dev		fixed			Unreviewed	0	0	0	0	0	0