From 9daf8b4109c3e133eb57349bb44d73cc60c5773c Mon Sep 17 00:00:00 2001
From: Simon Charette <charette.s@gmail.com>
Date: Thu, 6 Apr 2023 08:19:53 -0400
Subject: Fixed #34464 -- Fixed queryset aggregation over group by reference.

Regression in 59bea9efd2768102fc9d3aedda469502c218e9b7.

Refs #28477.

Thanks Ian Cubitt for the report.
---
 tests/aggregation/tests.py | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'tests/aggregation')

diff --git a/tests/aggregation/tests.py b/tests/aggregation/tests.py
index c1ae9f0dd5..ae68c24563 100644
--- a/tests/aggregation/tests.py
+++ b/tests/aggregation/tests.py
@@ -36,6 +36,7 @@ from django.db.models.functions import (
     Greatest,
     Least,
     Lower,
+    Mod,
     Now,
     Pi,
     TruncDate,
@@ -2175,3 +2176,9 @@ class AggregateAnnotationPruningTests(TestCase):
         sql = ctx.captured_queries[0]["sql"].lower()
         self.assertEqual(sql.count("select"), 2, "Subquery wrapping required")
         self.assertEqual(sql.count("authors_count"), 2)
+
+    def test_referenced_group_by_annotation_kept(self):
+        queryset = Book.objects.values(pages_mod=Mod("pages", 10)).annotate(
+            mod_count=Count("*")
+        )
+        self.assertEqual(queryset.count(), 1)
-- 
cgit v1.3