From d639576f81d65d3b1dbfc710be2f726bed55ae50 Mon Sep 17 00:00:00 2001 From: Janne Koschinski Date: Sun, 18 Feb 2018 21:14:35 +0100 Subject: [PATCH] Ignore self messages Closes GH-317. --- src/core/SQL/PostgreSQL/select_buffer_bufferactivity.sql | 1 + src/core/SQL/SQLite/select_buffer_bufferactivity.sql | 1 + 2 files changed, 2 insertions(+) diff --git a/src/core/SQL/PostgreSQL/select_buffer_bufferactivity.sql b/src/core/SQL/PostgreSQL/select_buffer_bufferactivity.sql index 3156485a..2013c105 100644 --- a/src/core/SQL/PostgreSQL/select_buffer_bufferactivity.sql +++ b/src/core/SQL/PostgreSQL/select_buffer_bufferactivity.sql @@ -3,4 +3,5 @@ FROM (SELECT DISTINCT TYPE FROM backlog WHERE bufferid = :bufferid + AND flags & 1 = 0 AND messageid > :lastseenmsgid) t; diff --git a/src/core/SQL/SQLite/select_buffer_bufferactivity.sql b/src/core/SQL/SQLite/select_buffer_bufferactivity.sql index 3156485a..2013c105 100644 --- a/src/core/SQL/SQLite/select_buffer_bufferactivity.sql +++ b/src/core/SQL/SQLite/select_buffer_bufferactivity.sql @@ -3,4 +3,5 @@ FROM (SELECT DISTINCT TYPE FROM backlog WHERE bufferid = :bufferid + AND flags & 1 = 0 AND messageid > :lastseenmsgid) t; -- 2.20.1