Skip to content

MSC4354 Sticky Events implementation has workaround for our SQLite supported versions situation #19452

@reivilibre

Description

@reivilibre

I'm going to merge #19365 with somewhat dodgy SQLite version gating for the experimental Sticky Events feature (#19409).

The problem is: we need to get some field out of the internal_metadata JSON payload and using JSON operators introduced in SQLite 3.38 is the least painful way to do this.
But despite our minimum supported version being 3.40, we only enforce 3.37 and this is what is used on Ubuntu 22.04: #19428

Since this feature is experimental, I feel OK with this workaround for now, but we need to sort out the situation and then remove the workaround (at which point this ticket can be closed).
This ticket also means this feature doesn't get any 'olddeps' testing under SQLite.

The effect of this ticket is that, when ready, these commits should be undone:

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions