Exclude with many condition in the same related field's fields

[Mounir]

When trying to exclude with many conditions in the same related field the generated query (tested in Postgresql) will not be the desired one.
E.g. If I have a model Student and a model Teacher, Student have a ForeignKey to Teacher model.

Teacher.objects.exclude(student__age=20, student__note__lt=5).query

Which will results in this query:

SELECT "teachers_teacher"."id", "teachers_teacher"."name" FROM "teachers_teacher" WHERE NOT ("teachers_teacher"."id" IN (SELECT U1."teacher_id" AS Col1 FROM "teachers_student" U1 WHERE U1."age" = 20) AND "teachers_teacher"."id" IN (SELECT U1."teacher_id" AS Col1 FROM "teachers_student" U1 WHERE U1."note" < 5))

I think the right SQL will be the following:

SELECT "teachers_teacher"."id", "teachers_teacher"."name" FROM "teachers_teacher" WHERE NOT ("teachers_teacher"."id" IN (SELECT U1."teacher_id" AS Col1 FROM "teachers_student" U1 WHERE U1."age" = 20 AND U1."note" < 5))

Even if the fix will be need a lot of work, I think it's better to mention this in the exclude documentation.

[Tim Graham]

I believe that's a duplicate of #14645. ​The documentation already contains a note about it.

[Mounir]

Thank you and sorry for the duplicate, I would suggest to mention this in the documentation of the ​exclude

Replying to Tim Graham:

I believe that's a duplicate of #14645. ​The documentation already contains a note about it.