Add several MSSQL dialect tests for sequence declarations

1 files changed, 24 insertions, 0 deletions

diff --git a/test/dialect/test_mssql.py b/test/dialect/test_mssql.py
index bf4e93758..f1c4b4df4 100644
--- a/test/dialect/test_mssql.py
+++ b/test/dialect/test_mssql.py
@@ -483,6 +483,30 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL):
             checkparams={u'x_1': 5}
         )
 
+    def test_sequence_start_0(self):
+        metadata = MetaData()
+        tbl = Table('test', metadata,
+                    Column('id', Integer, Sequence('', 0), primary_key=True))
+        self.assert_compile(schema.CreateTable(tbl),
+                            "CREATE TABLE test (id INTEGER NOT NULL IDENTITY(0,1), "
+                            "PRIMARY KEY (id))"
+                            )
+
+    def test_sequence_non_primary_key(self):
+        metadata = MetaData()
+        tbl = Table('test', metadata,
+                    Column('id', Integer, Sequence(''), primary_key=False))
+        self.assert_compile(schema.CreateTable(tbl),
+                            "CREATE TABLE test (id INTEGER NOT NULL IDENTITY(1,1))"
+                            )
+
+    def test_sequence_ignore_nullability(self):
+        metadata = MetaData()
+        tbl = Table('test', metadata,
+                    Column('id', Integer, Sequence(''), nullable=True))
+        self.assert_compile(schema.CreateTable(tbl),
+                            "CREATE TABLE test (id INTEGER NOT NULL IDENTITY(1,1))"
+                            )
 
 class SchemaAliasingTest(fixtures.TestBase, AssertsCompiledSQL):
     """SQL server cannot reference schema-qualified tables in a SELECT statement, they