Opened 6 years ago

Closed 5 years ago

Last modified 5 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 by Mads Jensen, 6 years ago

Has patch: set
Patch needs improvement: set

​PR

comment:2 by Tim Graham, 6 years ago

Triage Stage: Unreviewed → Accepted

comment:3 by Mads Jensen, 6 years ago

Patch needs improvement: unset

I think it can go in the review stage.

comment:4 by Tim Graham, 6 years ago

Patch needs improvement: set

comment:5 by Mads Jensen, 6 years ago

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

comment:6 by Tim Graham <timograham@…>, 5 years ago

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 by Tim Graham <timograham@…>, 5 years ago

In e5b8626:

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

comment:8 by GitHub <noreply@…>, 5 years ago

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