[3.0.x] Fixed #30986 -- Fixed queryset crash when filtering against boolean RawSQL expressions on Oracle.

Backport of 8685e764efd2957085762d9249e07794d9a58dcb from master

1 files changed, 8 insertions, 0 deletions

diff --git a/tests/expressions/tests.py b/tests/expressions/tests.py
index f50c634014..39dc2680fc 100644
--- a/tests/expressions/tests.py
+++ b/tests/expressions/tests.py
@@ -91,6 +91,14 @@ class BasicExpressionsTests(TestCase):
             2,
         )
 
+    def test_filtering_on_rawsql_that_is_boolean(self):
+        self.assertEqual(
+            Company.objects.filter(
+                RawSQL('num_employees > %s', (3,), output_field=models.BooleanField()),
+            ).count(),
+            2,
+        )
+
     def test_filter_inter_attribute(self):
         # We can filter on attribute relationships on same model obj, e.g.
         # find companies where the number of employees is greater