sql: Fix population of lastmsgid for empty buffers

[quassel.git] / src / core / SQL / PostgreSQL / version / 20 / upgrade_001_add_function_populate_lastmsgid.sql

diff --git a/src/core/SQL/PostgreSQL/version/20/upgrade_001_add_function_populate_lastmsgid.sql b/src/core/SQL/PostgreSQL/version/20/upgrade_001_add_function_populate_lastmsgid.sql
index 561422a..79c82a9 100644 (file)
--- a/src/core/SQL/PostgreSQL/version/20/upgrade_001_add_function_populate_lastmsgid.sql
+++ b/src/core/SQL/PostgreSQL/version/20/upgrade_001_add_function_populate_lastmsgid.sql
@@ -5,12 +5,12 @@ BEGIN
        FOR i IN SELECT * FROM buffer
        LOOP
                UPDATE buffer
-                       SET lastmsgid = (
+                       SET lastmsgid = COALESCE((
                                SELECT backlog.messageid
                                FROM backlog
                                WHERE backlog.bufferid = i.bufferid
                                ORDER BY messageid DESC LIMIT 1
-                       )
+                       ), 0)
                        WHERE buffer.bufferid = i.bufferid;
        END LOOP;
        RETURN;