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
32828	Wrong .count() for GROUP BY on ordered queryset	Maxim Petrov	nobody	"{{{#!python
class Foo(models.Model):
    name = models.TextField()
    date = models.DateTimeField()

queryset = Foo.objects.order_by(""date"").values(""name"").annotate(models.Count(""name""))
}}}

For this queryset Django use date in GROUP BY:
{{{#!sql
SELECT ""foo"".""name"", COUNT(""foo"".""name"") AS ""name__count"" FROM ""foo"" GROUP BY ""foo"".""name"", ""foo"".""date"" ORDER BY ""foo"".""date"" ASC
}}}
But `queryset.count()` doesn't use it:
{{{#!sql
SELECT COUNT(*) FROM (SELECT ""foo"".""name"" AS Col1, COUNT(""foo"".""name"") AS ""name__count"" FROM ""foo"" GROUP BY ""foo"".""name"")
}}}
So `queryset.count()` isn't equal real queryset length."	Bug	closed	Database layer (models, ORM)	3.2	Normal	invalid			Unreviewed	0	0	0	0	0	0