synapse/storage/schema/main/delta/16/remove_duplicates.sql


1
2
3
4
5
6
7
8
9

DELETE FROM event_to_state_groups WHERE state_group not in (
    SELECT MAX(state_group) FROM event_to_state_groups GROUP BY event_id
);

DELETE FROM event_to_state_groups WHERE rowid not in (
    SELECT MIN(rowid) FROM event_to_state_groups GROUP BY event_id
);