summaryrefslogtreecommitdiff
path: root/tests/postgres_tests
diff options
context:
space:
mode:
Diffstat (limited to 'tests/postgres_tests')
-rw-r--r--tests/postgres_tests/test_search.py4
1 files changed, 4 insertions, 0 deletions
diff --git a/tests/postgres_tests/test_search.py b/tests/postgres_tests/test_search.py
index 8944c6342d..f5111ce8d3 100644
--- a/tests/postgres_tests/test_search.py
+++ b/tests/postgres_tests/test_search.py
@@ -113,6 +113,10 @@ class SearchVectorFieldTest(GrailTestData, PostgreSQLTestCase):
searched = Line.objects.filter(dialogue_search_vector=SearchQuery('cadeaux', config='french'))
self.assertSequenceEqual(searched, [self.french])
+ def test_single_coalesce_expression(self):
+ searched = Line.objects.annotate(search=SearchVector('dialogue')).filter(search='cadeaux')
+ self.assertNotIn('COALESCE(COALESCE', str(searched.query))
+
class MultipleFieldsTest(GrailTestData, PostgreSQLTestCase):