X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fselect_messagesAllNew_filtered.sql;h=2bf44e2ca54c9573c0ee6e149358228ee223d906;hp=780263fc2b407677b78d92d1904a8a97f8475084;hb=85087a839d89dc53ed71b41e12244e57f21f67b1;hpb=3c910a417a72dfa529ad514d9a616139b7d57bab diff --git a/src/core/SQL/PostgreSQL/select_messagesAllNew_filtered.sql b/src/core/SQL/PostgreSQL/select_messagesAllNew_filtered.sql index 780263fc..2bf44e2c 100644 --- a/src/core/SQL/PostgreSQL/select_messagesAllNew_filtered.sql +++ b/src/core/SQL/PostgreSQL/select_messagesAllNew_filtered.sql @@ -4,6 +4,6 @@ JOIN sender ON backlog.senderid = sender.senderid WHERE backlog.bufferid IN (SELECT bufferid FROM buffer WHERE userid = :userid) AND backlog.messageid >= :firstmsg AND backlog.type & :type != 0 - AND (:flags = 0 OR backlog.flags & :flags != 0) + AND (:flags = 0 OR backlog.flags & :flagsDup1 != 0) ORDER BY messageid DESC -- Unlike SQLite, no LIMIT clause, mimicking the unfiltered version - investigate later..?