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
10847	`QuerySet.values` doesn't remove extra selections.	Tai Lee	nobody	"{{{
>>> from django.contrib.auth.models import User
>>> str(User.objects.extra(select={'extra_col': '1'}).values('pk').query)
'SELECT (1) AS ""extra_col"", ""auth_user"".""id"" FROM ""auth_user""'
}}}

This can cause problems when you need to do use your queryset with an IN field lookup.

{{{
>>> User.objects.filter(pk__in=User.objects.extra(select={'extra_col': '1'}).values('pk').query)
Traceback (most recent call last):
...
OperationalError: only a single result allowed for a SELECT that is part of an expression
}}}
"		closed	Database layer (models, ORM)	dev		fixed	queryset extra select values sql		Accepted	1	0	0	1	0	0