summary refs log tree commit diff
path: root/synapse/storage/databases
diff options
context:
space:
mode:
authorEric Eastwood <erice@element.io>2023-06-07 11:47:01 -0500
committerGitHub <noreply@github.com>2023-06-07 11:47:01 -0500
commite536f02f68135a8494f80ded75d1a53b98cbcb8d (patch)
tree05b27334784f872f2ec0b79e726a9c3fe88c2b37 /synapse/storage/databases
parentRemove redundant `room_memberships` join to find participating servers in a r... (diff)
downloadsynapse-e536f02f68135a8494f80ded75d1a53b98cbcb8d.tar.xz
Remove superfluous `room_memberships` join from background update (#15733)
Spawning from https://github.com/matrix-org/synapse/pull/15731
Diffstat (limited to 'synapse/storage/databases')
-rw-r--r--synapse/storage/databases/main/roommember.py1
1 files changed, 0 insertions, 1 deletions
diff --git a/synapse/storage/databases/main/roommember.py b/synapse/storage/databases/main/roommember.py
index 1b8ec67f54..582875c91a 100644
--- a/synapse/storage/databases/main/roommember.py
+++ b/synapse/storage/databases/main/roommember.py
@@ -1460,7 +1460,6 @@ class RoomMemberBackgroundUpdateStore(SQLBaseStore):
                 SELECT stream_ordering, event_id, events.room_id, event_json.json
                 FROM events
                 INNER JOIN event_json USING (event_id)
-                INNER JOIN room_memberships USING (event_id)
                 WHERE ? <= stream_ordering AND stream_ordering < ?
                 AND type = 'm.room.member'
                 ORDER BY stream_ordering DESC