git » sdk » commit 0b975ab

Group by sender_id as well

author Stephen Paul Weber
2025-06-24 18:39:54 UTC
committer Stephen Paul Weber
2025-06-24 18:39:54 UTC
parent 82a9e84a72df0ff73c56eb6644f0f9f839696bf0
Group by sender_id as well

Another sender may have used the same localId
snikket/persistence/Sqlite.hx +1 -1 
diff --git a/snikket/persistence/Sqlite.hx b/snikket/persistence/Sqlite.hx
index 322f301..f92be19 100644
--- a/snikket/persistence/Sqlite.hx
+++ b/snikket/persistence/Sqlite.hx
@@ -384,7 +384,7 @@ class Sqlite implements Persistence implements KeyValueStore {
 			q += " AND messages.created_at " + op + "CAST(unixepoch(?, 'subsec') * 1000 AS INTEGER)";
 			params.push(time);
 		}
-		q += " GROUP BY correction_id ORDER BY messages.created_at";
+		q += " GROUP BY correction_id, messages.sender_id ORDER BY messages.created_at";
 		if (op == "<" || op == "<=") q += " DESC";
 		q += ", messages.ROWID";
 		if (op == "<" || op == "<=") q += " DESC";