element-hq / element-hq/synapse
`register_background_index_update` does not create partial indexes on sqlite
Open
A-Database
O-Uncommon
S-Tolerable
T-Enhancement
- Dominant language
- Python
- Stars
- 4.6k
- Forks
- 600
- Avg merge
- 5d 22h
- Merged PRs (30d)
- 51
Description
This issue has been migrated from [#13636](https://github.com/matrix-org/synapse/issues/13636).
---
`register_background_index_update` does not create partial indexes on SQLite for compatibility with SQLite 3.7 (see [comments](https://github.com/matrix-org/synapse/blob/v1.65.0/synapse/storage/background_updates.py#L584-L585); however, we haven't supported that for a long time.
We should probably make this match the behaviour on postgres.
Contributor guide
Assessment
This issue has not been assessed yet.