diff options
| author | Thomasina Lee <thomasina.lee@titanemail.com> | 2019-05-17 15:27:01 +0100 |
|---|---|---|
| committer | Mariusz Felisiak <felisiak.mariusz@gmail.com> | 2019-05-20 08:34:06 +0200 |
| commit | c38e7a79f4354ee831f92deb7a658fc0387e3bec (patch) | |
| tree | 478dcd1c9b1b32dcf8fe54cd495af4365b9762ac /tests/postgres_tests/test_search.py | |
| parent | 04042b2b440f0bf50eb908d52cfe76af430e1738 (diff) | |
Fixed #30488 -- Removed redundant Coalesce call in SQL generated by SearchVector.
Regression in 405c8363362063542e9e79beac53c8437d389520.
Diffstat (limited to 'tests/postgres_tests/test_search.py')
| -rw-r--r-- | tests/postgres_tests/test_search.py | 4 |
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): |