Fixed #30986 -- Fixed queryset crash when filtering against boolean RawSQL expressions on Oracle.

1 files changed, 8 insertions, 0 deletions

diff --git a/tests/expressions/tests.py b/tests/expressions/tests.py
index 1dba3d083a..ee8b246966 100644
--- a/tests/expressions/tests.py
+++ b/tests/expressions/tests.py
@@ -92,6 +92,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