[1.11.x] Fixed #28817 -- Made QuerySet.iterator() use server-side cursors after values() and values_list().

Backport of d97f026a7ab5212192426e45121f7a52751a2044 from master

1 files changed, 4 insertions, 4 deletions

diff --git a/django/db/models/query.py b/django/db/models/query.py
index 8a97e45b88..379edf3882 100644
--- a/django/db/models/query.py
+++ b/django/db/models/query.py
@@ -103,7 +103,7 @@ class ValuesIterable(BaseIterable):
         # extra(select=...) cols are always at the start of the row.
         names = extra_names + field_names + annotation_names
 
-        for row in compiler.results_iter():
+        for row in compiler.results_iter(chunked_fetch=self.chunked_fetch):
             yield dict(zip(names, row))
 
 
@@ -119,7 +119,7 @@ class ValuesListIterable(BaseIterable):
         compiler = query.get_compiler(queryset.db)
 
         if not query.extra_select and not query.annotation_select:
-            for row in compiler.results_iter():
+            for row in compiler.results_iter(chunked_fetch=self.chunked_fetch):
                 yield tuple(row)
         else:
             field_names = list(query.values_select)
@@ -135,7 +135,7 @@ class ValuesListIterable(BaseIterable):
             else:
                 fields = names
 
-            for row in compiler.results_iter():
+            for row in compiler.results_iter(chunked_fetch=self.chunked_fetch):
                 data = dict(zip(names, row))
                 yield tuple(data[f] for f in fields)
 
@@ -149,7 +149,7 @@ class FlatValuesListIterable(BaseIterable):
     def __iter__(self):
         queryset = self.queryset
         compiler = queryset.query.get_compiler(queryset.db)
-        for row in compiler.results_iter():
+        for row in compiler.results_iter(chunked_fetch=self.chunked_fetch):
             yield row[0]