#34931: QuerySet .count() crashes when queryset contains FilteredRelation
referencing annotation in condition
-------------------------------------+-------------------------------------
Reporter: Ben Nace | Owner: nobody
Type: Bug | Status: new
Component: Database | Version: 4.2
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
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
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/34931>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/0107018b6d3ef9a7-73cdd0b3-3c5e-489e-8b8c-28dd04b6198f-000000%40eu-central-1.amazonses.com.
