- generalized Enum to issue a CHECK constraint + VARCHAR on default platform

- added native_enum=False flag to do the same on MySQL, PG, if desired

1 files changed, 19 insertions, 0 deletions

diff --git a/test/dialect/test_postgresql.py b/test/dialect/test_postgresql.py
index 4e9a324d4..626d54677 100644
--- a/test/dialect/test_postgresql.py
+++ b/test/dialect/test_postgresql.py
@@ -132,6 +132,25 @@ class EnumTest(TestBase, AssertsExecutionResults, AssertsCompiledSQL):
             postgresql.DropEnumType(e2), 
             "DROP TYPE someschema.somename"
         )
+        
+        t1 = Table('sometable', MetaData(), Column('somecolumn', e1))
+        self.assert_compile(
+            schema.CreateTable(t1),
+            "CREATE TABLE sometable ("
+            "somecolumn somename"
+            ")"
+        )
+        t1 = Table('sometable', MetaData(), 
+                    Column('somecolumn', Enum('x', 'y', 'z', native_enum=False))
+                )
+        self.assert_compile(
+            schema.CreateTable(t1),
+            "CREATE TABLE sometable ("
+            "somecolumn VARCHAR(1), "
+            " CHECK (somecolumn IN ('x','y','z'))"
+            ")"
+        )
+
     
     @testing.fails_on('postgresql+zxjdbc', 
                         'zxjdbc fails on ENUM: column "XXX" is of type XXX '