[1.11.x] Fixed #28175 -- Fixed __in lookups on a foreign key when using the foreign key's parent model as the lookup value.

Thanks Simon Charette for review.

Backport of d66378a8b2d48d41b56ba3622189493e4edf9e5a from master

1 files changed, 6 insertions, 0 deletions

diff --git a/tests/model_inheritance_regress/tests.py b/tests/model_inheritance_regress/tests.py
index e51dfca9dc..c91d7cb853 100644
--- a/tests/model_inheritance_regress/tests.py
+++ b/tests/model_inheritance_regress/tests.py
@@ -474,6 +474,12 @@ class ModelInheritanceTest(TestCase):
         jane = Supplier.objects.order_by("name").select_related("restaurant")[0]
         self.assertEqual(jane.restaurant.name, "Craft")
 
+    def test_filter_with_parent_fk(self):
+        r = Restaurant.objects.create()
+        s = Supplier.objects.create(restaurant=r)
+        # The mismatch between Restaurant and Place is intentional (#28175).
+        self.assertSequenceEqual(Supplier.objects.filter(restaurant__in=Place.objects.all()), [s])
+
     def test_ptr_accessor_assigns_db(self):
         r = Restaurant.objects.create()
         self.assertEqual(r.place_ptr._state.db, 'default')