From a354c69055fd818e612ce22eaa2da0576a4b89ee Mon Sep 17 00:00:00 2001
From: Simon Charette <charette.s@gmail.com>
Date: Thu, 6 Apr 2017 20:28:21 -0400
Subject: Fixed #28038 -- Restored casting to text of builtin lookups on
 PostgreSQL.

Reverted 658f1e8 which broke code using __icontains's implicit cast to ::text
on ArrayField.

Thanks Peter J. Farrell for the report.
---
 tests/postgres_tests/test_array.py | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'tests/postgres_tests/test_array.py')

diff --git a/tests/postgres_tests/test_array.py b/tests/postgres_tests/test_array.py
index 69ae5f3cda..a11b60e261 100644
--- a/tests/postgres_tests/test_array.py
+++ b/tests/postgres_tests/test_array.py
@@ -216,6 +216,14 @@ class TestQuerying(PostgreSQLTestCase):
             self.objs[1:3]
         )
 
+    def test_icontains(self):
+        # Using the __icontains lookup with ArrayField is inefficient.
+        instance = CharArrayModel.objects.create(field=['FoO'])
+        self.assertSequenceEqual(
+            CharArrayModel.objects.filter(field__icontains='foo'),
+            [instance]
+        )
+
     def test_contains_charfield(self):
         # Regression for #22907
         self.assertSequenceEqual(
-- 
cgit v1.3