add a float exclusion to help oursql build 100%

3 files changed, 13 insertions, 0 deletions

diff --git a/lib/sqlalchemy/testing/requirements.py b/lib/sqlalchemy/testing/requirements.py
index 0350cd06b..3a299b0db 100644
--- a/lib/sqlalchemy/testing/requirements.py
+++ b/lib/sqlalchemy/testing/requirements.py
@@ -373,6 +373,15 @@ class SuiteRequirements(Requirements):
         return exclusions.closed()
 
     @property
+    def floats_to_four_decimals(self):
+        """target backend can return a floating-point number with four
+        significant digits (such as 15.7563) accurately
+        (i.e. without FP inaccuracies, such as 15.75629997253418).
+
+        """
+        return exclusions.open()
+
+    @property
     def text_type(self):
         """Target database must support an unbounded Text() "
         "type such as TEXT or CLOB"""
diff --git a/lib/sqlalchemy/testing/suite/test_types.py b/lib/sqlalchemy/testing/suite/test_types.py
index 0d8bfdc0f..0de462eb7 100644
--- a/lib/sqlalchemy/testing/suite/test_types.py
+++ b/lib/sqlalchemy/testing/suite/test_types.py
@@ -283,6 +283,7 @@ class NumericTest(fixtures.TestBase):
             [15.7563, None],
         )
 
+    @testing.requires.floats_to_four_decimals
     def test_float_as_decimal(self):
         self._do_test(
             Float(precision=8, asdecimal=True),
diff --git a/test/requirements.py b/test/requirements.py
index e2637087d..a9cb44b57 100644
--- a/test/requirements.py
+++ b/test/requirements.py
@@ -536,6 +536,9 @@ class DefaultRequirements(SuiteRequirements):
                 ]
                 )
 
+    @property
+    def floats_to_four_decimals(self):
+        return fails_if("mysql+oursql", "Floating point error")
 
     @property
     def python2(self):