From 7e4b371eb070d892e9c27eacbe140c78b7d34059 Mon Sep 17 00:00:00 2001 From: Adam Johnson Date: Wed, 21 May 2025 14:48:59 +0200 Subject: [5.2.x] Fixed #36405 -- Fixed OrderableAggMixin.order_by using OuterRef. co-authored-by: Simon Charette Backport of c2615a050036eda0bca090c707191076220cee9f from main. --- tests/postgres_tests/test_aggregates.py | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'tests/postgres_tests') diff --git a/tests/postgres_tests/test_aggregates.py b/tests/postgres_tests/test_aggregates.py index ddd3b6bbd0..0037fb9f83 100644 --- a/tests/postgres_tests/test_aggregates.py +++ b/tests/postgres_tests/test_aggregates.py @@ -350,6 +350,18 @@ class TestGeneralAggregate(PostgreSQLTestCase): [[], [], [], []], ) + def test_array_agg_with_order_by_outer_ref(self): + StatTestModel.objects.annotate( + atm_ids=Subquery( + AggregateTestModel.objects.annotate( + ids=ArrayAgg( + "id", + order_by=[OuterRef("int1")], + ) + ).values("ids")[:1] + ) + ) + def test_bit_and_general(self): values = AggregateTestModel.objects.filter(integer_field__in=[0, 1]).aggregate( bitand=BitAnd("integer_field") -- cgit v1.3