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
30992	missing column in generated SQL at exclude() function call	wckao	nobody	"With the following model definitions
{{{
from django.db import models


class Audience(models.Model):
    name = models.TextField(max_length=10)


class User(models.Model):
    audience = models.ForeignKey(Audience, on_delete=models.CASCADE)


class Tracking(models.Model):
    user = models.ForeignKey(User, on_delete=models.CASCADE)
    datetime = models.DateTimeField()


class Conversion(models.Model):
    user = models.ForeignKey(User, on_delete=models.CASCADE)
    datetime = models.DateTimeField()
}}}

When issuing the following query
{{{
Conversion.objects.exclude(user__audience__user__tracking__datetime__gte=F('datetime'))
}}}

the following exception is raised
{{{
OperationalError: no such column: U2.id
}}}

"	Bug	closed	Database layer (models, ORM)	2.2	Normal	duplicate			Unreviewed	0	0	0	0	0	0