remove_duplicates.sql « 16 « delta « schema « storage « synapse - matrix/thirdparty/synapse.git - Unnamed repository; edit this file 'description' to name the repository.

index : matrix/thirdparty/synapse.git

Unnamed repository; edit this file 'description' to name the repository.

summary refs log tree commit diff

path: root/synapse/storage/schema/delta/16/remove_duplicates.sql

blob: 65c97b5e2ff7675f017e8a1c1828b642aa8e2ed2 (plain) (blame)

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
);