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
37273	Composite primary key exact lookups don’t support F() expressions on the RHS	Pravin	Pravin	"An exact lookup on a {{{CompositePrimaryKey}}} accepts a literal tuple but rejects an {{{F()}}} expression referencing a compatible composite primary key.

for example,

{{{
class Comment(models.Model):
    pk = models.CompositePrimaryKey(""tenant_id"", ""id"")
    tenant_id = models.IntegerField()
    id = models.IntegerField()
    text = models.TextField()
}}}

The following works.
{{{
comment = Comment.objects.first()
Comment.objects.filter(pk=(comment.tenant_id, comment.id))
}}}

but below one fails.
{{{
Comment.objects.filter(pk=models.F(""pk""))
}}}

it raises
{{{ ValueError: 'exact' subquery lookup of 'pk' only supports OuterRef and QuerySet objects (received 'ColPairs') }}}"	Bug	assigned	Database layer (models, ORM)	dev	Normal		CompositeField, CompositePrimaryKey, Filter, RHS	Pravin	Accepted	1	0	0	0	0	0