diff options
| author | Erik Johnston <erik@matrix.org> | 2014-09-25 15:51:21 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2014-09-25 15:51:21 +0100 |
| commit | c818aa13eb47c9d30da26645850a2af2672edf68 (patch) | |
| tree | 891724e680cb6343de4a4d948ca5795d122cf842 /synapse/storage/roommember.py | |
| parent | More tests. (diff) | |
| download | synapse-c818aa13eb47c9d30da26645850a2af2672edf68.tar.xz | |
Add LIMIT to scalar subquery
Diffstat (limited to 'synapse/storage/roommember.py')
| -rw-r--r-- | synapse/storage/roommember.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/synapse/storage/roommember.py b/synapse/storage/roommember.py index 84c462330b..958e730591 100644 --- a/synapse/storage/roommember.py +++ b/synapse/storage/roommember.py @@ -183,7 +183,8 @@ class RoomMemberStore(SQLBaseStore): def _get_members_query_txn(self, txn, where_clause, where_values): del_sql = ( - "SELECT event_id FROM redactions WHERE redacts = e.event_id" + "SELECT event_id FROM redactions WHERE redacts = e.event_id " + "LIMIT 1" ) sql = ( |