summary refs log tree commit diff
path: root/unscoop.c
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2020-01-11 20:28:32 -0500
committerJune McEnroe <june@causal.agency>2020-01-11 20:28:32 -0500
commit5833e14598e1972f551a2788286038feee359587 (patch)
treef853ca3f84bedb2efc0ba7793d5547f8b4c2ef3f /unscoop.c
parentBump busy timeout to 10s (diff)
downloadlitterbox-5833e14598e1972f551a2788286038feee359587.tar.gz
litterbox-5833e14598e1972f551a2788286038feee359587.zip
Fix unscoop dedup window syntax
Diffstat (limited to 'unscoop.c')
-rw-r--r--unscoop.c2
1 files changed, 1 insertions, 1 deletions
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
 			)