#31770: Enable has_select_for_update_of feature on MySQL -------------------------------------+------------------------------------- Reporter: Simon Charette | Owner: nobody Type: New feature | Status: new Component: Database layer | Version: 3.0 (models, ORM) | Severity: Normal | Resolution: Keywords: | Triage Stage: | Unreviewed Has patch: 0 | Needs documentation: 0 Needs tests: 0 | Patch needs improvement: 0 Easy pickings: 0 | UI/UX: 0 -------------------------------------+------------------------------------- Description changed by Simon Charette:
Old description: > While the `SELECT FOR UPDATE` > [https://dev.mysql.com/doc/refman/8.0/en/select.html#idm45705194357888 > documentation now mentions the] `OF` option I > [https://www.oracle.com/search/results?Ntt=%22FOR%20UPDATE%20OF%22&Dy=1&Nty=1&cat=mysql&Ntk > =SI-ALL5 couldn't find a single entry in the release notes] so I'm not > sure which version of MySQL 8 supposedly added support for it. > > All the `tests/select_for_update` tests happen to pass when setting > `has_select_for_update_of = True` even on MySQL 5.5 so I'm not sure if > this was always supported and never documented or if the syntax was > always allowed and they just recently added support for it? > > In all cases it seems like the feature should be allowed since all > supported versions of MySQL allow it. New description: While the `SELECT FOR UPDATE` [https://dev.mysql.com/doc/refman/8.0/en/select.html#idm45705194357888 documentation now mentions the] `OF` option I [https://www.oracle.com/search/results?Ntt=%22FOR%20UPDATE%20OF%22&Dy=1&Nty=1&cat=mysql&Ntk =SI-ALL5 couldn't find a single entry in the release notes] so I'm not sure which version of MySQL supposedly added support for it. All the `tests/select_for_update` tests happen to pass when setting `has_select_for_update_of = True` even on MySQL 5.5 so I'm not sure if this was always supported and never documented or if the syntax was always allowed and they just recently added support for it? Only the MySQL 8 documentation mentions it though. In all cases it seems like the feature should be allowed since all supported versions of MySQL allow it. -- -- Ticket URL: <https://code.djangoproject.com/ticket/31770#comment:1> 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 django-updates+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/067.62cc9a4e3d7c9ace57fd77783b63d1ca%40djangoproject.com.