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
32006	Aggregation generates wrong SQL query on PostgreSQL partionned tables.	Konstantin Popov	nobody	"I use values and annotate on QuerySet to make query for my report.
When I add 'id' or 'pk' field to another fields in values it becomes the only field in GROUP BY clause.
This, obviously, generates an invalid SQL query.

{{{ str(Currency.objects.filter(status=3).values('sifr','guid').annotate(cnt=Count('*')).query) }}}

'SELECT ""rk7data_currency"".""sifr"", ""rk7data_currency"".""guid"", COUNT(*) AS ""cnt"" FROM ""rk7data_currency"" WHERE ""rk7data_currency"".""status"" = 3 GROUP BY ""rk7data_currency"".""sifr"", ""rk7data_currency"".""guid""'

{{{ str(Currency.objects.filter(status=3).values('sifr','guid','id').annotate(cnt=Count('*')).query) }}}

'SELECT ""rk7data_currency"".""sifr"", ""rk7data_currency"".""guid"", ""rk7data_currency"".""id"", COUNT(*) AS ""cnt"" FROM ""rk7data_currency"" WHERE ""rk7data_currency"".""status"" = 3 GROUP BY ""rk7data_currency"".""id""'

I have checked this on several models with the same result.
I have discovered this on django 2.2.10. Upgrade to 2.2.16 and even to 3.1 does not solve the problem."	Bug	closed	Database layer (models, ORM)	3.1	Normal	wontfix	QuerySet values annotate GROUP BY		Unreviewed	0	0	0	0	0	0