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
28664	basic subquery generates invalid sql	David Szotten	nobody	"
{{{
from django.db import models

class Foo(models.Model):
    a = models.IntegerField()
    b = models.IntegerField()


class Bar(models.Model):
    foo = models.ForeignKey(Foo, on_delete=models.CASCADE)
}}}


{{{
>>> print(Bar.objects.filter(foo=Foo.objects.filter(a=1)).query)

SELECT ""app_bar"".""id"", ""app_bar"".""foo_id"" FROM ""app_bar"" WHERE ""app_bar"".""foo_id"" = (SELECT U0.""id"", U0.""a"", U0.""b"" FROM ""app_foo"" U0 WHERE U0.""a"" = 1)
}}}

The subquery is selecting all columns, causing {{{django.db.utils.ProgrammingError: subquery must return only one column}}}"	Uncategorized	closed	Database layer (models, ORM)	dev	Normal	duplicate			Unreviewed	0	0	0	0	0	0