- add an "empty_inserts" requirement target plus a suite test

- add suite tests for basic explicit Sequence support, result-row column access (tests that name_normalize is set correctly among many other things)

1 files changed, 18 insertions, 0 deletions

diff --git a/lib/sqlalchemy/testing/suite/test_insert.py b/lib/sqlalchemy/testing/suite/test_insert.py
index b2b2a0aa8..e3ef2b206 100644
--- a/lib/sqlalchemy/testing/suite/test_insert.py
+++ b/lib/sqlalchemy/testing/suite/test_insert.py
@@ -107,6 +107,24 @@ class InsertBehaviorTest(fixtures.TablesTest):
         assert r.is_insert
         assert not r.returns_rows
 
+    @requirements.empty_inserts
+    def test_empty_insert(self):
+        r = config.db.execute(
+            self.tables.autoinc_pk.insert(),
+            )
+        assert r.closed
+
+        r = config.db.execute(
+            self.tables.autoinc_pk.select()
+        )
+
+        eq_(
+            r.fetchall(),
+            [(1, None)]
+        )
+
+
+
 
 class ReturningTest(fixtures.TablesTest):
     run_deletes = 'each'