X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fselect_messagesAll_filtered.sql;h=1eb6278c5a48ca7d76e048431a7530efab1d372a;hp=3e1ce6554fec3b1a54bd4f729b84c2aa57503ebb;hb=85087a839d89dc53ed71b41e12244e57f21f67b1;hpb=3c910a417a72dfa529ad514d9a616139b7d57bab diff --git a/src/core/SQL/PostgreSQL/select_messagesAll_filtered.sql b/src/core/SQL/PostgreSQL/select_messagesAll_filtered.sql index 3e1ce655..1eb6278c 100644 --- a/src/core/SQL/PostgreSQL/select_messagesAll_filtered.sql +++ b/src/core/SQL/PostgreSQL/select_messagesAll_filtered.sql @@ -5,6 +5,6 @@ WHERE backlog.bufferid IN (SELECT bufferid FROM buffer WHERE userid = :userid) AND backlog.messageid >= :firstmsg AND backlog.messageid < :lastmsg 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..?