Exclude query on M2M field with F() fails

[daishi]

Given the following models:

class A(models.Model):
    pass

class B(models.Model):
    a = models.ManyToManyField(A)

class C(models.Model):
    a = models.ForeignKey(A)
    b = models.ForeignKey(B)

The following test:

a1 = A()
a1.save()
a2 = A()
a2.save()
b1 = B()
b1.save()
b1.a.add(a1)
b1.save()
b2 = B()
b2.save()
b2.a.add(a2)
b2.save()
c1 = C(a=a1, b=b1)
c1.save()
c2 = C(a=a1, b=b2)
c2.save()
self.assertEqual(1, C.objects.filter(b__a=F('a')).count())
self.assertEqual(1, C.objects.exclude(b__a=F('a')).count())

Fails with the following error:

OperationalError: no such column: U2.id

The SQL generated by Django for the C.objects.exclude(b__a=F('a')) fragment is logged as:

SELECT "a_c"."id", "a_c"."a_id", "a_c"."b_id" FROM "a_c" WHERE NOT ("a_c"."b_id" IN (SELECT U3."b_id" AS Col1 FROM "a_c" U0 INNER JOIN "a_b_a" U3 ON (U2."id" = U3."b_id") WHERE U3."a_id" = (U0."a_id"))) LIMIT 21; args=()

As suggested in the error, the U2 join table does not seem to be defined in the generated query.

[Tim Graham]

Looks like a duplicate of #21703.