]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
dont rely on default_isolation_level to restore engine-level iso
authorMike Bayer <mike_mp@zzzcomputing.com>
Wed, 26 Jul 2023 16:10:48 +0000 (12:10 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Wed, 26 Jul 2023 21:24:34 +0000 (17:24 -0400)
commita23cdcc12c8302a1a2deebb64876aaada8c996f6
tree0be580f1b5e268e54e8dd22c5f8dd853502fdeba
parent944283a3cecfccbd3431763c5713d784a998ad09
dont rely on default_isolation_level to restore engine-level iso

Fixed critical issue where setting
:paramref:`_sa.create_engine.isolation_level` to ``AUTOCOMMIT`` (as opposed
to using the :meth:`_engine.Engine.execution_options` method) would fail to
restore "autocommit" to a pooled connection if an alternate isolation level
were temporarily selected using
:paramref:`_engine.Connection.execution_options.isolation_level`.

Fixes: #10147
Change-Id: Ia22c15ab460cbbf8f6a731660874ace10df7c6a6
doc/build/changelog/unreleased_20/10147.rst [new file with mode: 0644]
lib/sqlalchemy/engine/default.py
lib/sqlalchemy/testing/requirements.py
lib/sqlalchemy/testing/suite/test_dialect.py