X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F14%2Fselect_messagesRange.sql;h=9bd86134aaa5186b5afa96928e3e1b2835e988a4;hp=e7a6a5a6761f3c293288af67f012d50ef40fe532;hb=4bb04fc5758f566e58d560d6f8c510c5cb038486;hpb=ebe8328821ff05692eb8f420cd0e54083d8b0927 diff --git a/src/core/SQL/PostgreSQL/14/select_messagesRange.sql b/src/core/SQL/PostgreSQL/14/select_messagesRange.sql index e7a6a5a6..9bd86134 100644 --- a/src/core/SQL/PostgreSQL/14/select_messagesRange.sql +++ b/src/core/SQL/PostgreSQL/14/select_messagesRange.sql @@ -1,6 +1,6 @@ SELECT messageid, time, type, flags, sender, message FROM backlog -JOIN sender ON backlog.senderid = sender.senderid +LEFT JOIN sender ON backlog.senderid = sender.senderid WHERE backlog.messageid >= $1 AND backlog.messageid < $2 AND bufferid = $3