Refs #28329 -- Fixed Cast() with ForeignKey to integer fields on MySQL.

1 files changed, 9 insertions, 0 deletions

diff --git a/tests/db_functions/comparison/test_cast.py b/tests/db_functions/comparison/test_cast.py
index afb6b473b9..80375cc389 100644
--- a/tests/db_functions/comparison/test_cast.py
+++ b/tests/db_functions/comparison/test_cast.py
@@ -76,6 +76,15 @@ class CastTests(TestCase):
                 numbers = Author.objects.annotate(cast_int=Cast("alias", field_class()))
                 self.assertEqual(numbers.get().cast_int, 1)
 
+    def test_cast_to_integer_foreign_key(self):
+        numbers = Author.objects.annotate(
+            cast_fk=Cast(
+                models.Value("0"),
+                models.ForeignKey(Author, on_delete=models.SET_NULL),
+            )
+        )
+        self.assertEqual(numbers.get().cast_fk, 0)
+
     def test_cast_to_duration(self):
         duration = datetime.timedelta(days=1, seconds=2, microseconds=3)
         DTModel.objects.create(duration=duration)