Opened 4 years ago

Closed 4 years ago

Last modified 4 years ago

#29547 closed New feature (fixed)

Support for partial/filtered indexes

Reported by: Mads Jensen Owned by: Mads Jensen
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords: db-indexes
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

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.

CREATE INDEX ... ON ... WHERE ...

Change History (8)

comment:1 Changed 4 years ago by Mads Jensen

Has patch: set
Patch needs improvement: set

​PR

comment:2 Changed 4 years ago by Tim Graham

Triage Stage: Unreviewed → Accepted

comment:3 Changed 4 years ago by Mads Jensen

Patch needs improvement: unset

I think it can go in the review stage.

comment:4 Changed 4 years ago by Tim Graham

Patch needs improvement: set

comment:5 Changed 4 years ago by Mads Jensen

Owner: changed from nobody to Mads Jensen
Patch needs improvement: unset
Status: new → assigned

comment:6 Changed 4 years ago by Tim Graham <timograham@…>

Resolution: → fixed
Status: assigned → closed

In a906c98:

Fixed #29547 -- Added support for partial indexes.

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

comment:7 Changed 4 years ago by Tim Graham <timograham@…>

In e5b8626:

Refs #29547 -- Corrected SQLite's supports_partial_indexes feature flag.

comment:8 Changed 4 years ago by GitHub <noreply@…>

In b74b6736:

Refs #29547 -- Skipped an unsupported partial index test on older versions of SQLite.

Follow up to e5b8626c0eb223cc3d643163882c5902c40ec972.

Note: See TracTickets for help on using tickets.
Back to Top