missing column in generated SQL at exclude() function call

[wckao]

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

[Simon Charette]

I confirm this was crashing on 2.2 and is passing with f19a4945e1191e1696f1ad8e6cdc6f939c702728 applied which is part of 3.0.

Closing as duplicate of #21703.