diff options
Diffstat (limited to 'tests/aggregation/tests.py')
| -rw-r--r-- | tests/aggregation/tests.py | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/tests/aggregation/tests.py b/tests/aggregation/tests.py index 61da0ebfe7..c6d73e8042 100644 --- a/tests/aggregation/tests.py +++ b/tests/aggregation/tests.py @@ -1434,6 +1434,18 @@ class AggregateTestCase(TestCase): ) self.assertTrue(publisher_qs.exists()) + def test_aggregation_filter_exists(self): + publishers_having_more_than_one_book_qs = ( + Book.objects.values("publisher") + .annotate(cnt=Count("isbn")) + .filter(cnt__gt=1) + ) + query = publishers_having_more_than_one_book_qs.query.exists( + using=connection.alias + ) + _, _, group_by = query.get_compiler(connection=connection).pre_sql_setup() + self.assertEqual(len(group_by), 1) + def test_aggregation_exists_annotation(self): published_books = Book.objects.filter(publisher=OuterRef("pk")) publisher_qs = Publisher.objects.annotate( |