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";