#31573: Support update().order_by() on MySQL.
-------------------------------------+-------------------------------------
Reporter: Gerben Morsink | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: update mysql order | Triage Stage: Accepted
order_by |
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Simon Charette):
* keywords: queryset update => update mysql order order_by
* type: Bug => New feature
* version: 2.2 => master
* stage: Unreviewed => Accepted
Comment:
MySQL seems to be only supported engine to allow `UPDATE ... ORDER BY` so
it doesn't seem to be standard.
- https://www.postgresql.org/docs/current/sql-update.html
- https://www.sqlite.org/draft/lang_update.html
-
https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/update_statement.htm
Since it's the documented way of dealing with the lack of deferrable
unique constraint on MySQL I guess we could add support for it.
--
Ticket URL: <https://code.djangoproject.com/ticket/31573#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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/064.489066ea3e33a1c0eef921a3012967ff%40djangoproject.com.
