diff options
| author | Gord Thompson <gord@gordthompson.com> | 2022-03-14 11:26:54 -0600 |
|---|---|---|
| committer | mike bayer <mike_mp@zzzcomputing.com> | 2022-03-14 18:51:05 +0000 |
| commit | 84a78a97b5903dc246155a63ee8514385ed95d7c (patch) | |
| tree | 06b0156a6b9a0b78b285fb816c26865aa9301654 /lib/sqlalchemy/dialects/mssql/base.py | |
| parent | 35f82173e04b3209e07fcfc0606a7614108d018e (diff) | |
| download | sqlalchemy-84a78a97b5903dc246155a63ee8514385ed95d7c.tar.gz | |
Fix "Ambiguous column name" error on FK reflection
Fixes: #7812
Change-Id: Ic16eff9a9201d34515cb8eb884270eced4e1196a
Diffstat (limited to 'lib/sqlalchemy/dialects/mssql/base.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/mssql/base.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py index 8c44c0b2d..dd792f70d 100644 --- a/lib/sqlalchemy/dialects/mssql/base.py +++ b/lib/sqlalchemy/dialects/mssql/base.py @@ -3422,7 +3422,8 @@ index_info AS ( AND index_info.index_name = fk_info.unique_constraint_name AND index_info.ordinal_position = fk_info.ordinal_position - ORDER BY constraint_schema, constraint_name, ordinal_position + ORDER BY fk_info.constraint_schema, fk_info.constraint_name, + fk_info.ordinal_position """ ) .bindparams( |