From 302e18eb75f29e651e67b18033487e40758d7c83 Mon Sep 17 00:00:00 2001 From: Federico Caselli Date: Tue, 1 Dec 2020 23:47:13 +0100 Subject: 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 --- lib/sqlalchemy/sql/compiler.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'lib/sqlalchemy/sql/compiler.py') diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py index 9b90bf868..d53fe01c2 100644 --- a/lib/sqlalchemy/sql/compiler.py +++ b/lib/sqlalchemy/sql/compiler.py @@ -4050,10 +4050,10 @@ class DDLCompiler(Compiled): text.append("NO MAXVALUE") if identity_options.cache is not None: text.append("CACHE %d" % identity_options.cache) - if identity_options.order is True: - text.append("ORDER") + if identity_options.order is not None: + text.append("ORDER" if identity_options.order else "NO ORDER") if identity_options.cycle is not None: - text.append("CYCLE") + text.append("CYCLE" if identity_options.cycle else "NO CYCLE") return " ".join(text) def visit_create_sequence(self, create, prefix=None, **kw): -- cgit v1.2.1