- add an explicit test for sequences "optional"

1 files changed, 16 insertions, 0 deletions

diff --git a/lib/sqlalchemy/testing/suite/test_sequence.py b/lib/sqlalchemy/testing/suite/test_sequence.py
index 0b60aa5b7..366d509cc 100644
--- a/lib/sqlalchemy/testing/suite/test_sequence.py
+++ b/lib/sqlalchemy/testing/suite/test_sequence.py
@@ -18,6 +18,12 @@ class SequenceTest(fixtures.TablesTest):
                 Column('data', String(50))
             )
 
+        Table('seq_opt_pk', metadata,
+                Column('id', Integer, Sequence('tab_id_seq', optional=True),
+                                                primary_key=True),
+                Column('data', String(50))
+            )
+
     def test_insert_roundtrip(self):
         config.db.execute(
             self.tables.seq_pk.insert(),
@@ -43,6 +49,16 @@ class SequenceTest(fixtures.TablesTest):
             r, 1
         )
 
+    @requirements.sequences_optional
+    def test_optional_seq(self):
+        r = config.db.execute(
+            self.tables.seq_opt_pk.insert(),
+            data="some data"
+        )
+        eq_(
+            r.inserted_primary_key,
+            [1]
+        )
 
 
     def _assert_round_trip(self, table, conn):