mssql: - [bug] Fixed bug where reflection of primary key constraint

    would double up columns if the same constraint/table
    existed in multiple schemas.
- force returns_rows to False for inserts where we know rows shouldnt be returned;
allows post_exec() to use the cursor without issue

1 files changed, 2 insertions, 0 deletions

diff --git a/lib/sqlalchemy/engine/base.py b/lib/sqlalchemy/engine/base.py
index e8b22fdc6..05ca0f980 100644
--- a/lib/sqlalchemy/engine/base.py
+++ b/lib/sqlalchemy/engine/base.py
@@ -882,8 +882,10 @@ class Connection(Connectable):
             if context._is_implicit_returning:
                 context._fetch_implicit_returning(result)
                 result.close(_autoclose_connection=False)
+                result._metadata = None
             elif not context._is_explicit_returning:
                 result.close(_autoclose_connection=False)
+                result._metadata = None
         elif result._metadata is None:
             # no results, get rowcount
             # (which requires open cursor on some drivers