[Django] #33508: MariaDB 10.8+ supports ordering on individual columns in the index.

Django

unread,

Feb 10, 2022, 4:33:20 AM2/10/22

to django-...@googlegroups.com

#33508: MariaDB 10.8+ supports ordering on individual columns in the index.
-------------------------------------+-------------------------------------
Reporter: Mariusz | Owner: nobody
Felisiak |
Type: | Status: new
Cleanup/optimization |
Component: Database | Version: 4.0
layer (models, ORM) |
Severity: Normal | Keywords: mariadb
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
MariaDB 10.8+ supports ordering on individual columns in the index, see
[https://mariadb.com/kb/en/mariadb-1080-release-notes/#descending-indexes
release notes]. We should correct the `supports_index_column_ordering`
feature flag.

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

Django

unread,

Feb 10, 2022, 5:49:36 AM2/10/22

to django-...@googlegroups.com

#33508: MariaDB 10.8+ supports ordering on individual columns in the index.
-------------------------------------+-------------------------------------

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

Changes (by Carlton Gibson):

* stage: Unreviewed => Accepted

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

Django

unread,

Feb 16, 2022, 8:47:21 AM2/16/22

to django-...@googlegroups.com

#33508: MariaDB 10.8+ supports ordering on individual columns in the index.
-------------------------------------+-------------------------------------

Reporter: Mariusz Felisiak | Owner: Alokik
Type: | Roy
Cleanup/optimization | Status: assigned

Component: Database layer | Version: 4.0
(models, ORM) |
Severity: Normal | Resolution:
Keywords: mariadb | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 0

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

Changes (by Alokik Roy):

* cc: Alokik Roy (added)
* owner: nobody => Alokik Roy
* status: new => assigned

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

Django

unread,

Feb 21, 2022, 10:40:37 AM2/21/22

to django-...@googlegroups.com

#33508: MariaDB 10.8+ supports ordering on individual columns in the index.
-------------------------------------+-------------------------------------

Has patch: 0 | Needs documentation: 0

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

Comment (by Alokik Roy):

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

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

Django

unread,

Feb 22, 2022, 5:45:00 AM2/22/22

to django-...@googlegroups.com

#33508: MariaDB 10.8+ supports ordering on individual columns in the index.
-------------------------------------+-------------------------------------

Has patch: 1 | Needs documentation: 0

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

Changes (by Alokik Roy):

* has_patch: 0 => 1

--
Ticket URL: <https://code.djangoproject.com/ticket/33508#comment:4>

Django

unread,

Feb 23, 2022, 1:27:02 AM2/23/22

to django-...@googlegroups.com

#33508: MariaDB 10.8+ supports ordering on individual columns in the index.
-------------------------------------+-------------------------------------

Keywords: mariadb | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0

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

Changes (by Mariusz Felisiak):

* stage: Accepted => Ready for checkin

--
Ticket URL: <https://code.djangoproject.com/ticket/33508#comment:5>

Django

unread,

Feb 26, 2022, 10:26:05 AM2/26/22

to django-...@googlegroups.com

#33508: MariaDB 10.8+ supports ordering on individual columns in the index.
-------------------------------------+-------------------------------------

Reporter: Mariusz Felisiak | Owner: Alokik
Type: | Roy

Cleanup/optimization | Status: closed

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

Severity: Normal | Resolution: fixed

Keywords: mariadb | Triage Stage: Ready for
| checkin

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:"c1d168be0fe7d848297253bdf2c5963dffda5af7" c1d168b]:
{{{
#!CommitTicketReference repository=""
revision="c1d168be0fe7d848297253bdf2c5963dffda5af7"
Fixed #33508 -- Fixed DatabaseFeatures.supports_index_column_ordering on
MariaDB 10.8+.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/33508#comment:6>

Django

unread,

Apr 20, 2022, 12:57:40 PM4/20/22

to django-...@googlegroups.com

#33508: MariaDB 10.8+ supports ordering on individual columns in the index.
-------------------------------------+-------------------------------------

Has patch: 1 | Needs documentation: 0

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

Comment (by Mariusz Felisiak <felisiak.mariusz@…>):

In [changeset:"6f311c7e35090957dd93783b71c5d3af7d5329d4" 6f311c7e]:
{{{
#!CommitTicketReference repository=""
revision="6f311c7e35090957dd93783b71c5d3af7d5329d4"
Refs #33508 -- Corrected note about MySQL/MariaDB support of index
ordering.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/33508#comment:7>

Reply all

Reply to author

Forward