diff options
| author | Federico Caselli <cfederico87@gmail.com> | 2022-05-18 22:20:01 +0200 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2022-05-20 15:24:41 -0400 |
| commit | 5e54d5f1ad022781f5d8c6c7da4802613050dde5 (patch) | |
| tree | e320c12cba8a54b035fcfa2d3cb2a5039b9f4be1 /lib/sqlalchemy/dialects/mssql | |
| parent | baae847ab2aaadb844b1701028f3c34746a73afb (diff) | |
| download | sqlalchemy-5e54d5f1ad022781f5d8c6c7da4802613050dde5.tar.gz | |
Use collation in reflection in MSSQL
Explicitly specify the collation when reflecting table columns using
MSSQL to prevent "collation conflict" errors.
Fixes: #8035
Change-Id: I4239a5ca8b041f56d7b3bba67b3357c176db31ee
Diffstat (limited to 'lib/sqlalchemy/dialects/mssql')
| -rw-r--r-- | lib/sqlalchemy/dialects/mssql/base.py | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py index 2e0238dcf..b4c620f91 100644 --- a/lib/sqlalchemy/dialects/mssql/base.py +++ b/lib/sqlalchemy/dialects/mssql/base.py @@ -3198,14 +3198,16 @@ class MSDialect(default.DefaultDialect): computed_cols, onclause=sql.and_( computed_cols.c.object_id == func.object_id(full_name), - computed_cols.c.name == columns.c.column_name, + computed_cols.c.name + == columns.c.column_name.collate("DATABASE_DEFAULT"), ), isouter=True, ).join( identity_cols, onclause=sql.and_( identity_cols.c.object_id == func.object_id(full_name), - identity_cols.c.name == columns.c.column_name, + identity_cols.c.name + == columns.c.column_name.collate("DATABASE_DEFAULT"), ), isouter=True, ) |