summaryrefslogtreecommitdiff
path: root/test/sql/test_metadata.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/test_metadata.py')
-rw-r--r--test/sql/test_metadata.py19
1 files changed, 19 insertions, 0 deletions
diff --git a/test/sql/test_metadata.py b/test/sql/test_metadata.py
index 7aa2059dc..ee7d372d7 100644
--- a/test/sql/test_metadata.py
+++ b/test/sql/test_metadata.py
@@ -3013,6 +3013,25 @@ class NamingConventionTest(fixtures.TestBase, AssertsCompiledSQL):
schema.CreateTable(u1).compile
)
+ def test_schematype_no_ck_name_boolean_no_name(self):
+ m1 = MetaData() # no naming convention
+
+ u1 = Table(
+ 'user', m1,
+ Column('x', Boolean())
+ )
+ # constraint gets special _defer_none_name
+ eq_(
+ [c for c in u1.constraints
+ if isinstance(c, CheckConstraint)][0].name, "_unnamed_"
+ )
+
+ self.assert_compile(
+ schema.CreateTable(u1),
+ "CREATE TABLE user (x BOOLEAN, CHECK (x IN (0, 1)))"
+ )
+
+
def test_ck_constraint_redundant_event(self):
u1 = self._fixture(naming_convention={
"ck": "ck_%(table_name)s_%(constraint_name)s"})