X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2Fversion%2F21%2Fupgrade_001_update_buffer_set_lastmsgid.sql;h=48fba7e29649f4b9d5ada107a9eefb1a68d48dc1;hp=221e814acd3a58bde0c0cdb86b58a58678b03e97;hb=f509a0d1065d4e42c9eb84e0ffab9e72517df04c;hpb=0260fbe00ddbd1ce78b1870f40fce969b8f34ee5

diff --git a/src/core/SQL/SQLite/version/21/upgrade_001_update_buffer_set_lastmsgid.sql b/src/core/SQL/SQLite/version/21/upgrade_001_update_buffer_set_lastmsgid.sql
index 221e814a..48fba7e2 100644
--- a/src/core/SQL/SQLite/version/21/upgrade_001_update_buffer_set_lastmsgid.sql
+++ b/src/core/SQL/SQLite/version/21/upgrade_001_update_buffer_set_lastmsgid.sql
@@ -1,8 +1,8 @@
 UPDATE buffer
-SET lastmsgid = (
+SET lastmsgid = COALESCE((
 	SELECT messageid 
 	FROM backlog 
 	WHERE backlog.bufferid = buffer.bufferid
 	ORDER BY messageid 
 	DESC LIMIT 1
-);
+), 0);