diff options
| author | June McEnroe <june@causal.agency> | 2020-01-11 20:28:32 -0500 |
|---|---|---|
| committer | June McEnroe <june@causal.agency> | 2020-01-11 20:28:32 -0500 |
| commit | 5833e14598e1972f551a2788286038feee359587 (patch) | |
| tree | f853ca3f84bedb2efc0ba7793d5547f8b4c2ef3f | |
| parent | Bump busy timeout to 10s (diff) | |
| download | litterbox-5833e14598e1972f551a2788286038feee359587.tar.gz litterbox-5833e14598e1972f551a2788286038feee359587.zip | |
Fix unscoop dedup window syntax
| -rw-r--r-- | unscoop.c | 2 |
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 ) |