[3.1.x] Fixed #31624 -- Avoided subquery usage on QuerySet.all().delete().

Thanks Adam Johnson for the report.

Regression in 7acef095d73322f45dcceb99afa1a4e50b520479.

Backport of 972000420e08703dd4981466ff67adcd5a61ad4b from master

1 files changed, 6 insertions, 0 deletions

diff --git a/tests/delete/tests.py b/tests/delete/tests.py
index c32ebba83f..e1ec26bc1a 100644
--- a/tests/delete/tests.py
+++ b/tests/delete/tests.py
@@ -605,6 +605,12 @@ class DeletionTests(TestCase):
 
 
 class FastDeleteTests(TestCase):
+    def test_fast_delete_all(self):
+        with self.assertNumQueries(1) as ctx:
+            User.objects.all().delete()
+        sql = ctx.captured_queries[0]['sql']
+        # No subqueries is used when performing a full delete.
+        self.assertNotIn('SELECT', sql)
 
     def test_fast_delete_fk(self):
         u = User.objects.create(