#30928: documentation of select_for_update is incorrect regarding MySQL
-----------------------------------------+------------------------
Reporter: Par Andersson | Owner: nobody
Type: Bug | Status: new
Component: Documentation | Version: 2.2
Severity: Normal | Keywords: mysql
Triage Stage: Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 1
UI/UX: 0 |
-----------------------------------------+------------------------
The documentation incorrectly claims that NOWAIT & SKIP LOCKED is not
supported by MySQL:
https://docs.djangoproject.com/en/dev/ref/models/querysets/#select-for-
update
{{{
Currently, the postgresql, oracle, and mysql database backends support
select_for_update(). However, MySQL doesn’t support the nowait,
skip_locked, and of arguments.
Passing nowait=True, skip_locked=True, or of to select_for_update() using
database backends that do not support these options, such as MySQL, raises
a NotSupportedError. This prevents code from unexpectedly blocking.
}}}
However MySQL added support for nowait and skip locked since version 8, as
documented here:
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
--
Ticket URL: <https://code.djangoproject.com/ticket/30928>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/051.d43b5323a538ffd1c8580821400655e9%40djangoproject.com.
