From 3d4e53bcb1f94e451f291e832bfa668361cd64a2 Mon Sep 17 00:00:00 2001 From: Thomasina Lee Date: Fri, 17 May 2019 15:27:01 +0100 Subject: [2.2.x] Fixed #30488 -- Removed redundant Coalesce call in SQL generated by SearchVector. Regression in 405c8363362063542e9e79beac53c8437d389520. Backport of c38e7a79f4354ee831f92deb7a658fc0387e3bec from master --- tests/postgres_tests/test_search.py | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'tests/postgres_tests') 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): -- cgit v1.3