liquid_feedback_core

changeset 561:fb2663ca1e6b

Added missing WHERE clause in "check_issue" function when updating snapshot IDs of issues
author jbe
date Mon Sep 25 14:20:07 2017 +0200 (2017-09-25)
parents 318827ecd041
children c3931054bb55
files core.sql update/core-update.v3.2.2-v4.0.0.sql
line diff
     1.1 --- a/core.sql	Thu Sep 21 17:45:13 2017 +0200
     1.2 +++ b/core.sql	Mon Sep 25 14:20:07 2017 +0200
     1.3 @@ -6061,11 +6061,14 @@
     1.4          "persist"."snapshot_created" = TRUE;
     1.5          IF "persist"."phase_finished" THEN
     1.6            IF "persist"."state" = 'admission' THEN
     1.7 -            UPDATE "issue" SET "admission_snapshot_id" = "latest_snapshot_id";
     1.8 +            UPDATE "issue" SET "admission_snapshot_id" = "latest_snapshot_id"
     1.9 +              WHERE "id" = "issue_id_p";
    1.10            ELSIF "persist"."state" = 'discussion' THEN
    1.11 -            UPDATE "issue" SET "half_freeze_snapshot_id" = "latest_snapshot_id";
    1.12 +            UPDATE "issue" SET "half_freeze_snapshot_id" = "latest_snapshot_id"
    1.13 +              WHERE "id" = "issue_id_p";
    1.14            ELSIF "persist"."state" = 'verification' THEN
    1.15 -            UPDATE "issue" SET "full_freeze_snapshot_id" = "latest_snapshot_id";
    1.16 +            UPDATE "issue" SET "full_freeze_snapshot_id" = "latest_snapshot_id"
    1.17 +              WHERE "id" = "issue_id_p";
    1.18              SELECT * INTO "issue_row" FROM "issue" WHERE "id" = "issue_id_p";
    1.19              SELECT * INTO "policy_row" FROM "policy"
    1.20                WHERE "id" = "issue_row"."policy_id";
     2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Thu Sep 21 17:45:13 2017 +0200
     2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Mon Sep 25 14:20:07 2017 +0200
     2.3 @@ -3104,11 +3104,14 @@
     2.4          "persist"."snapshot_created" = TRUE;
     2.5          IF "persist"."phase_finished" THEN
     2.6            IF "persist"."state" = 'admission' THEN
     2.7 -            UPDATE "issue" SET "admission_snapshot_id" = "latest_snapshot_id";
     2.8 +            UPDATE "issue" SET "admission_snapshot_id" = "latest_snapshot_id"
     2.9 +              WHERE "id" = "issue_id_p";
    2.10            ELSIF "persist"."state" = 'discussion' THEN
    2.11 -            UPDATE "issue" SET "half_freeze_snapshot_id" = "latest_snapshot_id";
    2.12 +            UPDATE "issue" SET "half_freeze_snapshot_id" = "latest_snapshot_id"
    2.13 +              WHERE "id" = "issue_id_p";
    2.14            ELSIF "persist"."state" = 'verification' THEN
    2.15 -            UPDATE "issue" SET "full_freeze_snapshot_id" = "latest_snapshot_id";
    2.16 +            UPDATE "issue" SET "full_freeze_snapshot_id" = "latest_snapshot_id"
    2.17 +              WHERE "id" = "issue_id_p";
    2.18              SELECT * INTO "issue_row" FROM "issue" WHERE "id" = "issue_id_p";
    2.19              SELECT * INTO "policy_row" FROM "policy"
    2.20                WHERE "id" = "issue_row"."policy_id";

Impressum / About Us