From 0f843fdd5b9b2f2307148465cd60f4e1b2befbb4 Mon Sep 17 00:00:00 2001 From: Mariusz Felisiak Date: Sat, 4 Jan 2020 20:49:11 +0100 Subject: Fixed #31136 -- Disabled grouping by aliases on QuerySet.values()/values_list(). MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Regression in fb3f034f1c63160c0ff13c609acd01c18be12f80. Thanks Sigurd Ljødal for the report. --- tests/aggregation/tests.py | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'tests/aggregation') diff --git a/tests/aggregation/tests.py b/tests/aggregation/tests.py index dd30f57bed..f523b3ca35 100644 --- a/tests/aggregation/tests.py +++ b/tests/aggregation/tests.py @@ -1151,6 +1151,20 @@ class AggregateTestCase(TestCase): ) self.assertTrue(publisher_qs.exists()) + def test_aggregation_exists_annotation(self): + published_books = Book.objects.filter(publisher=OuterRef('pk')) + publisher_qs = Publisher.objects.annotate( + published_book=Exists(published_books), + count=Count('book'), + ).values_list('name', flat=True) + self.assertCountEqual(list(publisher_qs), [ + 'Apress', + 'Morgan Kaufmann', + "Jonno's House of Books", + 'Prentice Hall', + 'Sams', + ]) + @skipUnlessDBFeature('supports_subqueries_in_group_by') def test_group_by_subquery_annotation(self): """ -- cgit v1.3