[Django] #29547: Support for partial/filtered indexes

[Django]

#29547: Support for partial/filtered indexes
-------------------------------------+-------------------------------------
Reporter: Mads | Owner: nobody
Jensen |
Type: New | Status: new
feature |
Component: Database | Version: master
layer (models, ORM) |
Severity: Normal | Keywords: db-indexes
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Partial indexes (or filtered indexes) is one of the few last missing
things in the index support for Django. It's supported widely, except for
MySQL and MariaDB. SQLite has support >= 3.8.

{{{
#!sql
CREATE INDEX ... ON ... WHERE ...
}}}

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

[Django]

#29547: Support for partial/filtered indexes
-------------------------------------+-------------------------------------

Reporter: Mads Jensen | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: db-indexes | Triage Stage:
| Unreviewed
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Mads Jensen):

* needs_better_patch: 0 => 1
* has_patch: 0 => 1

Comment:

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

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

[Django]

#29547: Support for partial/filtered indexes
-------------------------------------+-------------------------------------

Reporter: Mads Jensen | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:

Keywords: db-indexes | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Tim Graham):

* stage: Unreviewed => Accepted

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

[Django]

#29547: Support for partial/filtered indexes
-------------------------------------+-------------------------------------

Reporter: Mads Jensen | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: db-indexes | Triage Stage: Accepted

Has patch: 1 | Needs documentation: 0

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

Changes (by Mads Jensen):

* needs_better_patch: 1 => 0

Comment:

I think it can go in the review stage.

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

[Django]

#29547: Support for partial/filtered indexes
-------------------------------------+-------------------------------------

Reporter: Mads Jensen | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: db-indexes | Triage Stage: Accepted

Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Tim Graham):

* needs_better_patch: 0 => 1

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

[Django]

#29547: Support for partial/filtered indexes
-------------------------------------+-------------------------------------

Reporter: Mads Jensen | Owner: Mads
| Jensen
Type: New feature | Status: assigned

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: db-indexes | Triage Stage: Accepted

Has patch: 1 | Needs documentation: 0

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

Changes (by Mads Jensen):

* owner: nobody => Mads Jensen

* needs_better_patch: 1 => 0

* status: new => assigned

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

[Django]

#29547: Support for partial/filtered indexes
-------------------------------------+-------------------------------------

Reporter: Mads Jensen | Owner: Mads
| Jensen

Type: New feature | Status: closed

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

Severity: Normal | Resolution: fixed

Keywords: db-indexes | Triage Stage: Accepted

Has patch: 1 | Needs documentation: 0

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

Changes (by Tim Graham <timograham@…>):

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

Comment:

In [changeset:"a906c9898284a9aecb5f48bdc534e9c1273864a6" a906c98]:
{{{
#!CommitTicketReference repository=""
revision="a906c9898284a9aecb5f48bdc534e9c1273864a6"
Fixed #29547 -- Added support for partial indexes.

Thanks to Ian Foote, Mariusz Felisiak, Simon Charettes, and
Markus Holtermann for comments and feedback.
}}}

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

[Django]

#29547: Support for partial/filtered indexes
-------------------------------------+-------------------------------------

Reporter: Mads Jensen | Owner: Mads
| Jensen
Type: New feature | Status: closed
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: db-indexes | Triage Stage: Accepted

Has patch: 1 | Needs documentation: 0

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

Comment (by Tim Graham <timograham@…>):

In [changeset:"e5b8626c0eb223cc3d643163882c5902c40ec972" e5b8626]:
{{{
#!CommitTicketReference repository=""
revision="e5b8626c0eb223cc3d643163882c5902c40ec972"
Refs #29547 -- Corrected SQLite's supports_partial_indexes feature flag.
}}}

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

[Django]

#29547: Support for partial/filtered indexes
-------------------------------------+-------------------------------------

Reporter: Mads Jensen | Owner: Mads
| Jensen
Type: New feature | Status: closed
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: db-indexes | Triage Stage: Accepted

Has patch: 1 | Needs documentation: 0

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

Comment (by GitHub <noreply@…>):

In [changeset:"b74b6736d061b896220c0971e3a060ec2f6be12b" b74b6736]:
{{{
#!CommitTicketReference repository=""
revision="b74b6736d061b896220c0971e3a060ec2f6be12b"
Refs #29547 -- Skipped an unsupported partial index test on older versions
of SQLite.

Follow up to e5b8626c0eb223cc3d643163882c5902c40ec972.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/29547#comment:8>