id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
36787	In and Range lookups crash when provided to filter() if RHS contains mix of expressions and strings	Jacob Walls		"{{{#!diff
diff --git a/tests/lookup/tests.py b/tests/lookup/tests.py
index 5b9dd8e5ec..4cb90ed1d9 100644
--- a/tests/lookup/tests.py
+++ b/tests/lookup/tests.py
@@ -1847,6 +1847,8 @@ class LookupQueryingTests(TestCase):
             ((1842, 2042), (self.s2, self.s3)),
             ((1942, 1942, 1942), (self.s1,)),
             ((1942, 2042, 1842), (self.s1, self.s2, self.s3)),
+            # Mix expressions and string field references.
+            ((models.F(""year"") + 100, ""gt""), (self.s1,)),
         ]
 
         for years, seasons in test_cases:
).exists()
}}}
{{{#!py
======================================================================
ERROR: test_in_lookup_in_filter (lookup.tests.LookupQueryingTests.test_in_lookup_in_filter) (years=(<CombinedExpression: F(year) + Value(100)>, 'gt'), seasons=(<Season: 1942>,))
----------------------------------------------------------------------
Traceback (most recent call last):
  File ""/Users/jwalls/django/tests/lookup/tests.py"", line 1857, in test_in_lookup_in_filter
    Season.objects.filter(In(F(""year""), years)).order_by(""pk""), seasons
                          ~~^^^^^^^^^^^^^^^^^^
  File ""/Users/jwalls/django/django/db/models/lookups.py"", line 35, in __init__
    self.rhs = self.get_prep_lookup()
               ~~~~~~~~~~~~~~~~~~~~^^
  File ""/Users/jwalls/django/django/db/models/lookups.py"", line 517, in get_prep_lookup
    return super().get_prep_lookup()
           ~~~~~~~~~~~~~~~~~~~~~~~^^
  File ""/Users/jwalls/django/django/db/models/lookups.py"", line 310, in get_prep_lookup
    Value(prep_value, self.lhs.output_field)
                      ^^^^^^^^^^^^^^^^^^^^^
AttributeError: 'F' object has no attribute 'output_field'
}}}
Seems like 089deb82b9ac2d002af36fd36f288368cdac4b53 (5.2) needed the same tweak as 0bfaa55708d402432d44882d9a8e4cb85011472c (5.2)."	Bug	new	Database layer (models, ORM)	5.2	Normal				Unreviewed	0	0	0	0	0	0