diff options
Diffstat (limited to 'test/sql')
| -rw-r--r-- | test/sql/test_defaults.py | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/test/sql/test_defaults.py b/test/sql/test_defaults.py index 9aebfc010..b218aa53f 100644 --- a/test/sql/test_defaults.py +++ b/test/sql/test_defaults.py @@ -793,11 +793,18 @@ class SequenceDDLTest(fixtures.TestBase, testing.AssertsCompiledSQL): ) self.assert_compile( - CreateSequence(Sequence('foo_seq', increment=2, start=0, minvalue=0)), + CreateSequence(Sequence( + 'foo_seq', increment=2, start=0, minvalue=0)), "CREATE SEQUENCE foo_seq INCREMENT BY 2 START WITH 0 MINVALUE 0", ) self.assert_compile( + CreateSequence(Sequence( + 'foo_seq', increment=2, start=1, maxvalue=5)), + "CREATE SEQUENCE foo_seq INCREMENT BY 2 START WITH 0 MAXVALUE 5", + ) + + self.assert_compile( DropSequence(Sequence('foo_seq')), "DROP SEQUENCE foo_seq", ) |