From dfcdc8992f8bbbf072cefa4d325fe5cac5316f3d Mon Sep 17 00:00:00 2001 From: Jayantha Gumballi Date: Thu, 1 Nov 2018 20:44:34 +0530 Subject: Fixed #29886 -- Fixed unaccent lookup when PostgreSQL's standard_conforming_strings option is off. Thanks Tom McClure for the patch. --- tests/postgres_tests/test_unaccent.py | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) (limited to 'tests/postgres_tests/test_unaccent.py') diff --git a/tests/postgres_tests/test_unaccent.py b/tests/postgres_tests/test_unaccent.py index 018aedb64c..477bb3d653 100644 --- a/tests/postgres_tests/test_unaccent.py +++ b/tests/postgres_tests/test_unaccent.py @@ -1,3 +1,4 @@ +from django.db import connection from django.test import modify_settings from . import PostgreSQLTestCase @@ -42,6 +43,24 @@ class UnaccentTest(PostgreSQLTestCase): ordered=False ) + def test_unaccent_with_conforming_strings_off(self): + """SQL is valid when standard_conforming_strings is off.""" + with connection.cursor() as cursor: + cursor.execute('SHOW standard_conforming_strings') + disable_conforming_strings = cursor.fetchall()[0][0] == 'on' + if disable_conforming_strings: + cursor.execute('SET standard_conforming_strings TO off') + try: + self.assertQuerysetEqual( + self.Model.objects.filter(field__unaccent__endswith='éÖ'), + ['àéÖ', 'aeO'], + transform=lambda instance: instance.field, + ordered=False, + ) + finally: + if disable_conforming_strings: + cursor.execute('SET standard_conforming_strings TO on') + def test_unaccent_accentuated_needle(self): self.assertQuerysetEqual( self.Model.objects.filter(field__unaccent="aéÖ"), -- cgit v1.3