Add req for nullable booleans

Access doesn't allow for Yes/No columns to store null, so add
a rule for this.

Change-Id: If9316cd05733e39fbd59a6f54024f6740b563041

2 files changed, 7 insertions, 0 deletions

diff --git a/lib/sqlalchemy/testing/requirements.py b/lib/sqlalchemy/testing/requirements.py
index 9f0f87bb6..ca7a42db4 100644
--- a/lib/sqlalchemy/testing/requirements.py
+++ b/lib/sqlalchemy/testing/requirements.py
@@ -173,6 +173,12 @@ class SuiteRequirements(Requirements):
         return exclusions.closed()
 
     @property
+    def nullable_booleans(self):
+        """Target database allows boolean columns to store NULL."""
+
+        return exclusions.open()
+
+    @property
     def nullsordering(self):
         """Target backends that support nulls ordering."""
 
diff --git a/lib/sqlalchemy/testing/suite/test_types.py b/lib/sqlalchemy/testing/suite/test_types.py
index 3cc0ec1f6..37428c545 100644
--- a/lib/sqlalchemy/testing/suite/test_types.py
+++ b/lib/sqlalchemy/testing/suite/test_types.py
@@ -615,6 +615,7 @@ class BooleanTest(_LiteralRoundTripFixture, fixtures.TablesTest):
         eq_(row, (True, False))
         assert isinstance(row[0], bool)
 
+    @testing.requires.nullable_booleans
     def test_null(self):
         boolean_table = self.tables.boolean_table