Merge remote-tracking branch 'origin/pr/151' into pr151

3 files changed, 4 insertions, 1 deletions

diff --git a/test/sql/test_constraints.py b/test/sql/test_constraints.py
index 2f054dac1..c0b5806ac 100644
--- a/test/sql/test_constraints.py
+++ b/test/sql/test_constraints.py
@@ -130,6 +130,7 @@ class ConstraintGenTest(fixtures.TestBase, AssertsExecutionResults):
             *assertions
         )
 
+    @testing.requires.check_constraints
     @testing.provide_metadata
     def test_check_constraint_create(self):
         metadata = self.metadata
diff --git a/test/sql/test_metadata.py b/test/sql/test_metadata.py
index 74044e3bb..0aa5d7305 100644
--- a/test/sql/test_metadata.py
+++ b/test/sql/test_metadata.py
@@ -530,6 +530,7 @@ class MetaDataTest(fixtures.TestBase, ComparesTables):
 
 class ToMetaDataTest(fixtures.TestBase, ComparesTables):
 
+    @testing.requires.check_constraints
     def test_copy(self):
         from sqlalchemy.testing.schema import Table
         meta = MetaData()
@@ -1161,6 +1162,7 @@ class InfoTest(fixtures.TestBase):
 
 class TableTest(fixtures.TestBase, AssertsCompiledSQL):
 
+    @testing.requires.temporary_table
     @testing.skip_if('mssql', 'different col format')
     def test_prefixes(self):
         from sqlalchemy import Table
diff --git a/test/sql/test_types.py b/test/sql/test_types.py
index efa0f90ae..26dc6c842 100644
--- a/test/sql/test_types.py
+++ b/test/sql/test_types.py
@@ -558,7 +558,7 @@ class TypeCoerceCastTest(fixtures.TablesTest):
     @classmethod
     def define_tables(cls, metadata):
         class MyType(types.TypeDecorator):
-            impl = String
+            impl = String(50)
 
             def process_bind_param(self, value, dialect):
                 return "BIND_IN" + str(value)