Refs #20024 -- Tested __in lookups with None against composite pk fields.

1 files changed, 16 insertions, 0 deletions

diff --git a/tests/composite_pk/test_filter.py b/tests/composite_pk/test_filter.py
index c4b393d6ea..617d8370db 100644
--- a/tests/composite_pk/test_filter.py
+++ b/tests/composite_pk/test_filter.py
@@ -607,3 +607,19 @@ class CompositePKFilterTupleLookupFallbackTests(CompositePKFilterTests):
         )
         self.enterContext(feature_patch_1)
         self.enterContext(feature_patch_2)
+
+
+class CompositePKExcludeNoneTests(TestCase):
+    @classmethod
+    def setUpTestData(cls):
+        cls.tenant = Tenant.objects.create()
+        cls.user = User.objects.create(
+            tenant=cls.tenant, id=1, email="exclude@example.com"
+        )
+
+    def test_pk_in_with_partial_or_all_none(self):
+        qs = User.objects
+        self.assertQuerySetEqual(qs.filter(pk__in=[(1, None)]), [])
+        self.assertQuerySetEqual(qs.filter(pk__in=[(None, None)]), [])
+        self.assertQuerySetEqual(qs.exclude(pk__in=[(1, None)]), [self.user])
+        self.assertQuerySetEqual(qs.exclude(pk__in=[(None, None)]), [self.user])