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