]> 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 04:45:25 +0000 (23:45 -0500)
commitcbc31716c2cef29f45506c6227c2154e3093c845
tree9df380e01965a2c8b4641953722b090c2ad0d4a4
parentd514c032cd0349afc93f89d5b99835198ae70112
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
doc/build/changelog/unreleased_12/4536.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mssql/base.py
test/dialect/mssql/test_engine.py