[Django] #32342: Enable supports_index_column_ordering on MySQL 8.0.1+

[Django]

#32342: Enable supports_index_column_ordering on MySQL 8.0.1+
-------------------------------------+-------------------------------------
Reporter: Mariusz | Owner: Mariusz Felisiak
Felisiak |
Type: | Status: assigned
Cleanup/optimization |
Component: Database | Version: 3.1
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
MySQL 8.0.1+ supports descending indexes and introspection of columns
orders (`ASC`/`DESC`) for indexes, see

- [https://dev.mysql.com/doc/refman/8.0/en/show-index.html SHOW INDEX on
MySQL 8.0.1+],
- [https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
Descending Indexes]

Noticed when reviewing #26167. Refs #20888.

--
Ticket URL: <https://code.djangoproject.com/ticket/32342>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#32342: Enable supports_index_column_ordering on MySQL 8.0.1+
-------------------------------------+-------------------------------------

Reporter: Mariusz Felisiak | Owner: Mariusz
Type: | Felisiak
Cleanup/optimization | Status: assigned
Component: Database layer | Version: 3.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Mariusz Felisiak):

* has_patch: 0 => 1

Comment:

[https://github.com/django/django/pull/13875 PR]

--
Ticket URL: <https://code.djangoproject.com/ticket/32342#comment:1>

[Django]

#32342: Enable supports_index_column_ordering on MySQL 8.0.1+
-------------------------------------+-------------------------------------

Reporter: Mariusz Felisiak | Owner: Mariusz
Type: | Felisiak
Cleanup/optimization | Status: assigned
Component: Database layer | Version: 3.1
(models, ORM) |
Severity: Normal | Resolution:

Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Adam Johnson):

* stage: Unreviewed => Accepted

--
Ticket URL: <https://code.djangoproject.com/ticket/32342#comment:2>

[Django]

#32342: Enable supports_index_column_ordering on MySQL 8.0.1+
-------------------------------------+-------------------------------------

Reporter: Mariusz Felisiak | Owner: Mariusz
Type: | Felisiak

Cleanup/optimization | Status: closed

Component: Database layer | Version: 3.1
(models, ORM) |

Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by GitHub <noreply@…>):

* status: assigned => closed
* resolution: => fixed

Comment:

In [changeset:"407d3cf39cd6a62f7277e401d646a4c7e8446879" 407d3cf3]:
{{{
#!CommitTicketReference repository=""
revision="407d3cf39cd6a62f7277e401d646a4c7e8446879"
Fixed #32342 -- Added index order introspection on MySQL 8.0.1+.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/32342#comment:3>