diff options
| author | David Baker <dave@matrix.org> | 2014-12-18 15:06:11 +0000 |
|---|---|---|
| committer | David Baker <dave@matrix.org> | 2014-12-18 15:06:11 +0000 |
| commit | 0a6664493a6277d6b7b78b54e0b2a6da591ad158 (patch) | |
| tree | a01e93cb31ca94d83dba6a9a381997b88f5b3a25 /synapse/storage | |
| parent | Thank you, pyflakes (diff) | |
| parent | Merge branch 'hotfixes-v0.5.4' of github.com:matrix-org/synapse (diff) | |
| download | synapse-0a6664493a6277d6b7b78b54e0b2a6da591ad158.tar.xz | |
Merge branch 'master' into pushers
Diffstat (limited to 'synapse/storage')
| -rw-r--r-- | synapse/storage/roommember.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/synapse/storage/roommember.py b/synapse/storage/roommember.py index c37df59d45..05b275663e 100644 --- a/synapse/storage/roommember.py +++ b/synapse/storage/roommember.py @@ -218,7 +218,9 @@ class RoomMemberStore(SQLBaseStore): "ON m.event_id = c.event_id " "WHERE m.membership = 'join' " "AND (%(clause)s) " - "GROUP BY m.room_id HAVING COUNT(m.room_id) = ?" + # TODO(paul): We've got duplicate rows in the database somewhere + # so we have to DISTINCT m.user_id here + "GROUP BY m.room_id HAVING COUNT(DISTINCT m.user_id) = ?" ) % {"clause": user_list_clause} args = list(user_id_list) |