]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
feat: Support MySQL FOR SHARE locking syntax.
authorJetDrag <taptube@gmail.com>
Wed, 5 Nov 2025 03:47:02 +0000 (22:47 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Tue, 11 Nov 2025 00:20:54 +0000 (19:20 -0500)
commit59afd08a5206c69ce47c138c6e4f18b2c40e1ef6
tree8503a7c84c3d2337b99203ee629e8c7a9fbeb590
parent1bddbd9e58a2835dbc3539ffc38a93a4cb85a105
feat: Support MySQL FOR SHARE locking syntax.

Added support for MySQL 8.0.1 + ``FOR SHARE`` to be emitted for the
:meth:`.Select.with_for_uddate` method, which offers compatibility with
``NOWAIT`` and ``SKIP LOCKED``.  The new syntax is used only for MySQL when
version 8.0.1 or higher is detected. Pull request courtesy JetDrag.

Fixes: #10134
Closes: #12964
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/12964
Pull-request-sha: 03d5e37cfda5da9dab8ae00aa682521f8ab9190b

Change-Id: Iafb7a24363284edcfeead94a348f50a470a88403
doc/build/changelog/unreleased_20/12964.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mysql/base.py
test/dialect/mysql/test_for_update.py
test/requirements.py