From 872dade29c8a4b9e82920a85c698fcef8ed332ee Mon Sep 17 00:00:00 2001 From: Simon Charette Date: Mon, 27 Feb 2023 01:10:19 -0500 Subject: [4.2.x] Fixed #34372 -- Fixed queryset crash on order by aggregation using OrderBy. Regression in 278881e37619278789942513916acafaa88d26f3 caused by a lack of expression copying when an OrderBy expression is explicitly provided. Thanks Jannis Vajen for the report and regression test. Backport of b15f162f252610e3b510ade465549769ab4356cf from main --- django/db/models/sql/compiler.py | 2 ++ 1 file changed, 2 insertions(+) (limited to 'django/db/models/sql') diff --git a/django/db/models/sql/compiler.py b/django/db/models/sql/compiler.py index 348cfa381a..1faed5c416 100644 --- a/django/db/models/sql/compiler.py +++ b/django/db/models/sql/compiler.py @@ -358,11 +358,13 @@ class SQLCompiler: if ( field.nulls_first is None and field.nulls_last is None ) or self.connection.features.supports_order_by_nulls_modifier: + field = field.copy() field.expression = select_ref # Alias collisions are not possible when dealing with # combined queries so fallback to it if emulation of NULLS # handling is required. elif self.query.combinator: + field = field.copy() field.expression = Ref(select_ref.refs, select_ref.source) yield field, select_ref is not None continue -- cgit v1.3