]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Commit transaction after SNAPSHOT isolation change
authorMike Bayer <mike_mp@zzzcomputing.com>
Fri, 8 Mar 2019 23:36:33 +0000 (18:36 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Sat, 9 Mar 2019 18:07:16 +0000 (13:07 -0500)
commit117b05e2330d36109a7ba4e271ca896621b89372
treeea39ba8baca53d21cc11c57ab0ace081f619d4a5
parentfd358e1b61971f787feab9e68f85f5826c54c62f
Commit transaction after SNAPSHOT isolation change

A commit() is emitted after an isolation level change to SNAPSHOT, as both
pyodbc and pymssql open an implicit transaction which blocks subsequent SQL
from being emitted in the current transaction.

Fixes: #4536
Change-Id: If3ba70f495bce2a35a873a3a72d1b30406e678c8
(cherry picked from commit cbc31716c2cef29f45506c6227c2154e3093c845)
doc/build/changelog/unreleased_12/4536.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mssql/base.py
test/dialect/mssql/test_engine.py