summaryrefslogtreecommitdiff
path: root/tests/aggregation
diff options
context:
space:
mode:
authorMariusz Felisiak <felisiak.mariusz@gmail.com>2020-01-04 20:49:11 +0100
committerGitHub <noreply@github.com>2020-01-04 20:49:11 +0100
commit0f843fdd5b9b2f2307148465cd60f4e1b2befbb4 (patch)
tree8a7bd17d7c5a9510301e793591037f4ab14ddec5 /tests/aggregation
parent495d7a1ddf3c8c83d49f099ee3599afbc28306fe (diff)
Fixed #31136 -- Disabled grouping by aliases on QuerySet.values()/values_list().
Regression in fb3f034f1c63160c0ff13c609acd01c18be12f80. Thanks Sigurd Ljødal for the report.
Diffstat (limited to 'tests/aggregation')
-rw-r--r--tests/aggregation/tests.py14
1 files changed, 14 insertions, 0 deletions
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):
"""