Refs #32682 -- Fixed QuerySet.delete() crash on querysets with self-referential subqueries on MySQL.

2 files changed, 15 insertions, 0 deletions

diff --git a/tests/delete_regress/models.py b/tests/delete_regress/models.py
index 90eae1ba1c..e06da1288b 100644
--- a/tests/delete_regress/models.py
+++ b/tests/delete_regress/models.py
@@ -24,6 +24,7 @@ class Person(models.Model):
 
 class Book(models.Model):
     pagecount = models.IntegerField()
+    owner = models.ForeignKey('Child', models.CASCADE, null=True)
 
 
 class Toy(models.Model):
diff --git a/tests/delete_regress/tests.py b/tests/delete_regress/tests.py
index 97a7d6ba02..fe758eab74 100644
--- a/tests/delete_regress/tests.py
+++ b/tests/delete_regress/tests.py
@@ -1,6 +1,7 @@
 import datetime
 
 from django.db import connection, models, transaction
+from django.db.models import Exists, OuterRef
 from django.test import (
     SimpleTestCase, TestCase, TransactionTestCase, skipUnlessDBFeature,
 )
@@ -355,6 +356,19 @@ class DeleteTests(TestCase):
         self.assertEqual(researcher2.primary_contact, contact2)
         self.assertIsNone(researcher2.secondary_contact)
 
+    def test_self_reference_with_through_m2m_at_second_level(self):
+        toy = Toy.objects.create(name='Paints')
+        child = Child.objects.create(name='Juan')
+        Book.objects.create(pagecount=500, owner=child)
+        PlayedWith.objects.create(child=child, toy=toy, date=datetime.date.today())
+        Book.objects.filter(Exists(
+            Book.objects.filter(
+                pk=OuterRef('pk'),
+                owner__toys=toy.pk,
+            ),
+        )).delete()
+        self.assertIs(Book.objects.exists(), False)
+
 
 class DeleteDistinct(SimpleTestCase):
     def test_disallowed_delete_distinct(self):