summaryrefslogtreecommitdiff
path: root/tests/db_functions
diff options
context:
space:
mode:
Diffstat (limited to 'tests/db_functions')
-rw-r--r--tests/db_functions/comparison/test_coalesce.py13
1 files changed, 12 insertions, 1 deletions
diff --git a/tests/db_functions/comparison/test_coalesce.py b/tests/db_functions/comparison/test_coalesce.py
index 8ba4b01fe6..1093079d68 100644
--- a/tests/db_functions/comparison/test_coalesce.py
+++ b/tests/db_functions/comparison/test_coalesce.py
@@ -1,4 +1,4 @@
-from django.db.models import TextField
+from django.db.models import Subquery, TextField
from django.db.models.functions import Coalesce, Lower
from django.test import TestCase
from django.utils import timezone
@@ -70,3 +70,14 @@ class CoalesceTests(TestCase):
authors, ['John Smith', 'Rhonda'],
lambda a: a.name
)
+
+ def test_empty_queryset(self):
+ Author.objects.create(name='John Smith')
+ tests = [
+ Author.objects.none(),
+ Subquery(Author.objects.none()),
+ ]
+ for empty_query in tests:
+ with self.subTest(empty_query.__class__.__name__):
+ qs = Author.objects.annotate(annotation=Coalesce(empty_query, 42))
+ self.assertEqual(qs.first().annotation, 42)