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
31714	ResolvedOuterRef object has no get_lookup	BorisZZZ		"This looks like an issue very similar to #28621, only in this case the issue is cause by using the annotation on the LHS of a filter.
For example,
{{{
class A(models.Model):
    r = IntegerRangeField()
      
A.objects.annotate(x=OuterRef(""x"")).filter(x__contained_in=F(""r""))
}}}
will result in the following stack trace:
{{{
Traceback (most recent call last):
  ...
  File ""/usr/local/lib/python3.8/site-packages/django/db/models/query.py"", line 904, in filter
    return self._filter_or_exclude(False, *args, **kwargs)
  File ""/usr/local/lib/python3.8/site-packages/django/db/models/query.py"", line 923, in _filter_or_exclude
    clone.query.add_q(Q(*args, **kwargs))
  File ""/usr/local/lib/python3.8/site-packages/django/db/models/sql/query.py"", line 1350, in add_q
    clause, _ = self._add_q(q_object, self.used_aliases)
  File ""/usr/local/lib/python3.8/site-packages/django/db/models/sql/query.py"", line 1377, in _add_q
    child_clause, needed_inner = self.build_filter(
  File ""/usr/local/lib/python3.8/site-packages/django/db/models/sql/query.py"", line 1267, in build_filter
    condition = self.build_lookup(lookups, reffed_expression, value)
  File ""/usr/local/lib/python3.8/site-packages/django/db/models/sql/query.py"", line 1153, in build_lookup
    lookup_class = lhs.get_lookup(lookup_name)
AttributeError: 'ResolvedOuterRef' object has no attribute 'get_lookup'
}}}"	Cleanup/optimization	new	Database layer (models, ORM)	3.0	Normal			Denis Verbin	Accepted	0	0	0	0	0	0