From b63cc325a9362874a13f0079589afccd7d108f1f Mon Sep 17 00:00:00 2001
From: Erik Johnston <erik@matrix.org>
Date: Fri, 17 May 2019 18:01:39 +0100
Subject: Only count aggregations from distinct senders

As a user isn't allowed to send a single emoji more than once.
---
 synapse/storage/relations.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/synapse/storage/relations.py b/synapse/storage/relations.py
index 6e216066ab..42f587a7d8 100644
--- a/synapse/storage/relations.py
+++ b/synapse/storage/relations.py
@@ -280,7 +280,7 @@ class RelationsWorkerStore(SQLBaseStore):
             having_clause = ""
 
         sql = """
-            SELECT type, aggregation_key, COUNT(*), MAX(stream_ordering)
+            SELECT type, aggregation_key, COUNT(DISTINCT sender), MAX(stream_ordering)
             FROM event_relations
             INNER JOIN events USING (event_id)
             WHERE {where_clause}
-- 
cgit 1.4.1