Fixed #26056 -- Added QuerySet.values()/values_list() support for ArrayField's __overlap lookup.

Thanks Mads Jensen and kosz85 and the initial patch.

1 files changed, 8 insertions, 0 deletions

diff --git a/django/contrib/postgres/lookups.py b/django/contrib/postgres/lookups.py
index f2f88ebc0a..4e1783f288 100644
--- a/django/contrib/postgres/lookups.py
+++ b/django/contrib/postgres/lookups.py
@@ -1,5 +1,6 @@
 from django.db.models import Transform
 from django.db.models.lookups import PostgresOperatorLookup
+from django.db.models.sql.query import Query
 
 from .search import SearchVector, SearchVectorExact, SearchVectorField
 
@@ -18,6 +19,13 @@ class Overlap(PostgresOperatorLookup):
     lookup_name = "overlap"
     postgres_operator = "&&"
 
+    def get_prep_lookup(self):
+        from .expressions import ArraySubquery
+
+        if isinstance(self.rhs, Query):
+            self.rhs = ArraySubquery(self.rhs)
+        return super().get_prep_lookup()
+
 
 class HasKey(PostgresOperatorLookup):
     lookup_name = "has_key"