[1.10.x] Fixed #27828 -- Fixed a crash when subtracting Integer/DurationField from DateField on Oracle/PostgreSQL.

Thanks Mariusz Felisiak for the Oracle workaround.

Backport of d5088f838d837fc9e3109c828f18511055f20bea from master

1 files changed, 10 insertions, 1 deletions

diff --git a/tests/expressions/tests.py b/tests/expressions/tests.py
index 27929c9146..b1b07393b0 100644
--- a/tests/expressions/tests.py
+++ b/tests/expressions/tests.py
@@ -15,7 +15,7 @@ from django.db.models.expressions import (
     When,
 )
 from django.db.models.functions import (
-    Coalesce, Concat, Length, Lower, Substr, Upper,
+    Cast, Coalesce, Concat, Length, Lower, Substr, Upper,
 )
 from django.test import TestCase, skipIfDBFeature, skipUnlessDBFeature
 from django.test.utils import Approximate
@@ -908,6 +908,15 @@ class FTimeDeltaTests(TestCase):
         ).order_by('name')
         self.assertQuerysetEqual(over_estimate, ['e3', 'e4'], lambda e: e.name)
 
+    def test_date_minus_duration(self):
+        value = (
+            Cast(Value(datetime.timedelta(days=4)), models.DurationField())
+            if connection.vendor == 'oracle'
+            else Value(datetime.timedelta(days=4), output_field=models.DurationField())
+        )
+        more_than_4_days = Experiment.objects.filter(assigned__lt=F('completed') - value)
+        self.assertQuerysetEqual(more_than_4_days, ['e3', 'e4'], lambda e: e.name)
+
 
 class ValueTests(TestCase):
     def test_update_TimeField_using_Value(self):