diff options
| author | Federico Caselli <cfederico87@gmail.com> | 2020-12-01 23:47:13 +0100 |
|---|---|---|
| committer | Federico Caselli <cfederico87@gmail.com> | 2020-12-01 23:49:17 +0100 |
| commit | 302e18eb75f29e651e67b18033487e40758d7c83 (patch) | |
| tree | 1e3fb8a26f0956f0384f80033e7a9f3d38370e88 /test/dialect/oracle/test_compiler.py | |
| parent | 14c08d18885e16611b884bd76ba2811375de1731 (diff) | |
| download | sqlalchemy-302e18eb75f29e651e67b18033487e40758d7c83.tar.gz | |
Properly render ``cycle=False`` and ``order=False``
These get rendered as ``NO CYCLE`` and ``NO ORDER`` in
:class:`_sql.Sequence` and :class:`_sql.Identity` objects.
Fixes: #5738
Change-Id: Ia9ccb5481a104cb32d3b517e99efd5e730c84946
Diffstat (limited to 'test/dialect/oracle/test_compiler.py')
| -rw-r--r-- | test/dialect/oracle/test_compiler.py | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/test/dialect/oracle/test_compiler.py b/test/dialect/oracle/test_compiler.py index 20c579f64..1b8b3fb89 100644 --- a/test/dialect/oracle/test_compiler.py +++ b/test/dialect/oracle/test_compiler.py @@ -1286,13 +1286,16 @@ class CompileTest(fixtures.TestBase, AssertsCompiledSQL): increment=7, nominvalue=True, nomaxvalue=True, + cycle=False, + order=False, ), ), ) self.assert_compile( schema.CreateTable(t), "CREATE TABLE t (y INTEGER GENERATED ALWAYS AS IDENTITY " - "(INCREMENT BY 7 START WITH 4 NOMINVALUE NOMAXVALUE))", + "(INCREMENT BY 7 START WITH 4 NOMINVALUE NOMAXVALUE " + "NOORDER NOCYCLE))", ) def test_column_identity_no_generated(self): |