From 5833e14598e1972f551a2788286038feee359587 Mon Sep 17 00:00:00 2001 From: "C. McEnroe" Date: Sat, 11 Jan 2020 20:28:32 -0500 Subject: Fix unscoop dedup window syntax --- unscoop.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/unscoop.c b/unscoop.c index 7c04ca1..04e0ca7 100644 --- a/unscoop.c +++ b/unscoop.c @@ -286,7 +286,7 @@ static void dedupEvents(sqlite3 *db) { WITH potentials (event, diff) AS ( SELECT event, event - first_value(event) OVER matching FROM events JOIN names USING (name) - WINDOW matching ( + WINDOW matching AS ( PARTITION BY time, type, context, nick, target, message ORDER BY event ) -- cgit 1.4.1