- fix exclusion here

- mysql doesn't reset table counter here so test differently

2 files changed, 5 insertions, 8 deletions

diff --git a/lib/sqlalchemy/testing/requirements.py b/lib/sqlalchemy/testing/requirements.py
index 6cc1de96d..e032cdd4a 100644
--- a/lib/sqlalchemy/testing/requirements.py
+++ b/lib/sqlalchemy/testing/requirements.py
@@ -138,7 +138,8 @@ class SuiteRequirements(Requirements):
         INSERT DEFAULT VALUES or equivalent."""
 
         return exclusions.only_if(
-                    lambda: self.config.db.dialect.supports_empty_insert,
+                    lambda: self.config.db.dialect.supports_empty_insert or \
+                        self.config.db.dialect.supports_default_values,
                     "empty inserts not supported"
                 )
 
diff --git a/lib/sqlalchemy/testing/suite/test_insert.py b/lib/sqlalchemy/testing/suite/test_insert.py
index e3ef2b206..66aa1ecfa 100644
--- a/lib/sqlalchemy/testing/suite/test_insert.py
+++ b/lib/sqlalchemy/testing/suite/test_insert.py
@@ -115,15 +115,11 @@ class InsertBehaviorTest(fixtures.TablesTest):
         assert r.closed
 
         r = config.db.execute(
-            self.tables.autoinc_pk.select()
+            self.tables.autoinc_pk.select().\
+                    where(self.tables.autoinc_pk.c.id != None)
         )
 
-        eq_(
-            r.fetchall(),
-            [(1, None)]
-        )
-
-
+        assert len(r.fetchall())
 
 
 class ReturningTest(fixtures.TablesTest):