diff options
| author | Till <2353100+S7evinK@users.noreply.github.com> | 2022-04-27 21:31:30 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-04-27 21:31:30 +0200 |
| commit | 74259f296f225510e9fbb6c5aae191c3f86c729e (patch) | |
| tree | f450df2a440364aa306d4e2b6948f3ae8076faf1 /syncapi | |
| parent | 8d69e2f0b897dd1ecd99c7bd348ad8bfc8999c4e (diff) | |
Fix #2390 (#2392)
Fix duplicate heroes in `/sync` response.
Diffstat (limited to 'syncapi')
| -rw-r--r-- | syncapi/storage/postgres/memberships_table.go | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/syncapi/storage/postgres/memberships_table.go b/syncapi/storage/postgres/memberships_table.go index 8c049977..00223c57 100644 --- a/syncapi/storage/postgres/memberships_table.go +++ b/syncapi/storage/postgres/memberships_table.go @@ -64,7 +64,7 @@ const selectMembershipCountSQL = "" + ") t WHERE t.membership = $3" const selectHeroesSQL = "" + - "SELECT user_id FROM syncapi_memberships WHERE room_id = $1 AND user_id != $2 AND membership = ANY($3) LIMIT 5" + "SELECT DISTINCT user_id FROM syncapi_memberships WHERE room_id = $1 AND user_id != $2 AND membership = ANY($3) LIMIT 5" type membershipsStatements struct { upsertMembershipStmt *sql.Stmt |