allow SQLA-defaults on table columns that are excluded in the mapper

1 files changed, 19 insertions, 1 deletions

diff --git a/test/orm/defaults.py b/test/orm/defaults.py
index 9f1ecda10..844a81bc4 100644
--- a/test/orm/defaults.py
+++ b/test/orm/defaults.py
@@ -98,6 +98,24 @@ class TriggerDefaultsTest(_base.MappedTest):
         eq_(d1.col3, 'up')
         eq_(d1.col4, 'up')
 
-
+class ExcludedDefaultsTest(_base.MappedTest):
+    def define_tables(self, metadata):
+        dt = Table('dt', metadata,
+                   Column('id', Integer, primary_key=True),
+                   Column('col1', String(20), default="hello"),
+        )
+        
+    @testing.resolve_artifact_names
+    def test_exclude(self):
+        class Foo(_base.ComparableEntity):
+            pass
+        mapper(Foo, dt, exclude_properties=('col1',))
+    
+        f1 = Foo()
+        sess = create_session()
+        sess.add(f1)
+        sess.flush()
+        eq_(dt.select().execute().fetchall(), [(1, "hello")])
+    
 if __name__ == "__main__":
     testenv.main()