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 09:12:32 +0200 |
| commit | 3d4e53bcb1f94e451f291e832bfa668361cd64a2 (patch) | |
| tree | afd21c21825aa14b543b4a7b8fb3bcc66fb961f4 /tests/postgres_tests | |
| parent | db7d7901eeacf37f0a6f124e3733c4f121a23e76 (diff) | |
[2.2.x] Fixed #30488 -- Removed redundant Coalesce call in SQL generated by SearchVector.
Regression in 405c8363362063542e9e79beac53c8437d389520.
Backport of c38e7a79f4354ee831f92deb7a658fc0387e3bec from master
Diffstat (limited to 'tests/postgres_tests')
| -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): |