# HG changeset patch
# User jbe
# Date 1506342007 -7200
# Node ID fb2663ca1e6b2ea76d1ff90afc6625460723f655
# Parent  318827ecd0414302878685f1569adaf8f780caec
Added missing WHERE clause in "check_issue" function when updating snapshot IDs of issues

diff -r 318827ecd041 -r fb2663ca1e6b core.sql
--- a/core.sql	Thu Sep 21 17:45:13 2017 +0200
+++ b/core.sql	Mon Sep 25 14:20:07 2017 +0200
@@ -6061,11 +6061,14 @@
         "persist"."snapshot_created" = TRUE;
         IF "persist"."phase_finished" THEN
           IF "persist"."state" = 'admission' THEN
-            UPDATE "issue" SET "admission_snapshot_id" = "latest_snapshot_id";
+            UPDATE "issue" SET "admission_snapshot_id" = "latest_snapshot_id"
+              WHERE "id" = "issue_id_p";
           ELSIF "persist"."state" = 'discussion' THEN
-            UPDATE "issue" SET "half_freeze_snapshot_id" = "latest_snapshot_id";
+            UPDATE "issue" SET "half_freeze_snapshot_id" = "latest_snapshot_id"
+              WHERE "id" = "issue_id_p";
           ELSIF "persist"."state" = 'verification' THEN
-            UPDATE "issue" SET "full_freeze_snapshot_id" = "latest_snapshot_id";
+            UPDATE "issue" SET "full_freeze_snapshot_id" = "latest_snapshot_id"
+              WHERE "id" = "issue_id_p";
             SELECT * INTO "issue_row" FROM "issue" WHERE "id" = "issue_id_p";
             SELECT * INTO "policy_row" FROM "policy"
               WHERE "id" = "issue_row"."policy_id";
diff -r 318827ecd041 -r fb2663ca1e6b update/core-update.v3.2.2-v4.0.0.sql
--- a/update/core-update.v3.2.2-v4.0.0.sql	Thu Sep 21 17:45:13 2017 +0200
+++ b/update/core-update.v3.2.2-v4.0.0.sql	Mon Sep 25 14:20:07 2017 +0200
@@ -3104,11 +3104,14 @@
         "persist"."snapshot_created" = TRUE;
         IF "persist"."phase_finished" THEN
           IF "persist"."state" = 'admission' THEN
-            UPDATE "issue" SET "admission_snapshot_id" = "latest_snapshot_id";
+            UPDATE "issue" SET "admission_snapshot_id" = "latest_snapshot_id"
+              WHERE "id" = "issue_id_p";
           ELSIF "persist"."state" = 'discussion' THEN
-            UPDATE "issue" SET "half_freeze_snapshot_id" = "latest_snapshot_id";
+            UPDATE "issue" SET "half_freeze_snapshot_id" = "latest_snapshot_id"
+              WHERE "id" = "issue_id_p";
           ELSIF "persist"."state" = 'verification' THEN
-            UPDATE "issue" SET "full_freeze_snapshot_id" = "latest_snapshot_id";
+            UPDATE "issue" SET "full_freeze_snapshot_id" = "latest_snapshot_id"
+              WHERE "id" = "issue_id_p";
             SELECT * INTO "issue_row" FROM "issue" WHERE "id" = "issue_id_p";
             SELECT * INTO "policy_row" FROM "policy"
               WHERE "id" = "issue_row"."policy_id";