diff options
| author | David Baker <dave@matrix.org> | 2016-08-18 17:53:44 +0100 |
|---|---|---|
| committer | David Baker <dave@matrix.org> | 2016-08-18 17:53:44 +0100 |
| commit | 1e4217c90c730e8dc18e2f8ce11c15f498ad7909 (patch) | |
| tree | 38414ef39db7b36e4917fcf0b82d36f7cfdd2fe3 /synapse/storage | |
| parent | Use tuple comparison (diff) | |
| download | synapse-1e4217c90c730e8dc18e2f8ce11c15f498ad7909.tar.xz | |
Explicit join
Diffstat (limited to 'synapse/storage')
| -rw-r--r-- | synapse/storage/receipts.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/synapse/storage/receipts.py b/synapse/storage/receipts.py index cb4e04a679..2c1df0e2b9 100644 --- a/synapse/storage/receipts.py +++ b/synapse/storage/receipts.py @@ -100,8 +100,8 @@ class ReceiptsStore(SQLBaseStore): sql = ( "SELECT rl.room_id, rl.event_id," " e.topological_ordering, e.stream_ordering" - " FROM receipts_linearized rl," - " events e" + " FROM receipts_linearized AS rl" + " INNER JOIN events AS e USING (room_id, event_id)" " WHERE rl.room_id = e.room_id" " AND rl.event_id = e.event_id" " AND user_id = ?" |