summary refs log tree commit diff
path: root/synapse/storage/search.py
diff options
context:
space:
mode:
authorNeil Johnson <neil@fragile.org.uk>2018-04-26 15:44:54 +0100
committerNeil Johnson <neil@fragile.org.uk>2018-04-26 15:44:54 +0100
commit872158030301410016ec9d9236e89e484aa3fe73 (patch)
treecf9c4fffacb23511c27513a1f9e5c5e1e0e18a4a /synapse/storage/search.py
parentUpdate CHANGES.rst (diff)
parentMerge pull request #3134 from matrix-org/erikj/fix_admin_media_api (diff)
downloadsynapse-872158030301410016ec9d9236e89e484aa3fe73.tar.xz
Merge branch 'develop' of https://github.com/matrix-org/synapse into release-v0.28.0-rc1
Diffstat (limited to 'synapse/storage/search.py')
-rw-r--r--synapse/storage/search.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/synapse/storage/search.py b/synapse/storage/search.py
index 426cbe6e1a..6ba3e59889 100644
--- a/synapse/storage/search.py
+++ b/synapse/storage/search.py
@@ -77,7 +77,7 @@ class SearchStore(BackgroundUpdateStore):
             sql = (
                 "SELECT stream_ordering, event_id, room_id, type, json, "
                 " origin_server_ts FROM events"
-                " JOIN event_json USING (event_id)"
+                " JOIN event_json USING (room_id, event_id)"
                 " WHERE ? <= stream_ordering AND stream_ordering < ?"
                 " AND (%s)"
                 " ORDER BY stream_ordering DESC"