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
34931	QuerySet .count() crashes when queryset contains FilteredRelation referencing annotation in condition	Ben Nace	nobody	"With the following models:

{{{
from django.db import models


class ModelA(models.Model):
    threshold1 = models.PositiveIntegerField()
    threshold2 = models.PositiveIntegerField()


class ModelB(models.Model):
    model_a = models.ForeignKey(ModelA, on_delete=models.CASCADE)
    value = models.IntegerField()
}}}

Attempting the following query results in a FieldError:

{{{
from django.db.models import F, FilteredRelation, Q
ModelA.objects.annotate(combined_threshold=F('threshold1') + F('threshold2'), filtered_b=FilteredRelation('modelb', condition=Q(modelb__value__gte=F('combined_threshold')))).values('filtered_b__value').count()
}}}

{{{
Traceback (most recent call last):
  File ""<console>"", line 1, in <module>
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/query.py"", line 608, in count
    return self.query.get_count(using=self.db)
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/query.py"", line 568, in get_count
    return obj.get_aggregation(using, {""__count"": Count(""*"")})[""__count""]
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/query.py"", line 554, in get_aggregation
    result = compiler.execute_sql(SINGLE)
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/compiler.py"", line 1549, in execute_sql
    sql, params = self.as_sql()
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/compiler.py"", line 761, in as_sql
    from_, f_params = self.get_from_clause()
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/compiler.py"", line 1128, in get_from_clause
    clause_sql, clause_params = self.compile(from_clause)
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/compiler.py"", line 546, in compile
    sql, params = node.as_sql(self, self.connection)
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/datastructures.py"", line 105, in as_sql
    extra_sql, extra_params = compiler.compile(self.filtered_relation)
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/compiler.py"", line 546, in compile
    sql, params = node.as_sql(self, self.connection)
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/query_utils.py"", line 434, in as_sql
    where = query.build_filtered_relation_q(self.condition, reuse=set(self.path))
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/query.py"", line 1609, in build_filtered_relation_q
    child_clause, _ = self.build_filter(
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/query.py"", line 1435, in build_filter
    value = self.resolve_lookup_value(value, can_reuse, allow_joins)
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/query.py"", line 1204, in resolve_lookup_value
    value = value.resolve_expression(
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/expressions.py"", line 822, in resolve_expression
    return query.resolve_ref(self.name, allow_joins, reuse, summarize)
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/query.py"", line 1976, in resolve_ref
    join_info = self.setup_joins(
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/query.py"", line 1823, in setup_joins
    path, final_field, targets, rest = self.names_to_path(
  File ""/home/bnace/python-envs/pmcs-42/lib/python3.9/site-packages/django/db/models/sql/query.py"", line 1724, in names_to_path
    raise FieldError(
django.core.exceptions.FieldError: Cannot resolve keyword 'combined_threshold' into field. Choices are: __count, filtered_b, id, modelb, threshold1, threshold2
}}}


"	Bug	closed	Database layer (models, ORM)	4.2	Normal	duplicate			Unreviewed	0	0	0	0	0	0