liquid_feedback_core
changeset 562:c3931054bb55
Bugfix in "take_snapshot" function when determining unit_id
author | jbe |
---|---|
date | Mon Sep 25 14:30:02 2017 +0200 (2017-09-25) |
parents | fb2663ca1e6b |
children | fc09088587b2 |
files | core.sql update/core-update.v3.2.2-v4.0.0.sql |
line diff
1.1 --- a/core.sql Mon Sep 25 14:20:07 2017 +0200 1.2 +++ b/core.sql Mon Sep 25 14:30:02 2017 +0200 1.3 @@ -4942,7 +4942,7 @@ 1.4 SELECT "area_id" INTO "area_id_v" 1.5 FROM "issue" WHERE "id" = "issue_id_p"; 1.6 END IF; 1.7 - SELECT "unit_id" INTO "unit_id_v" FROM "area" WHERE "id" = "area_id_p"; 1.8 + SELECT "unit_id" INTO "unit_id_v" FROM "area" WHERE "id" = "area_id_v"; 1.9 INSERT INTO "snapshot" ("area_id", "issue_id") 1.10 VALUES ("area_id_v", "issue_id_p") 1.11 RETURNING "id" INTO "snapshot_id_v";
2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql Mon Sep 25 14:20:07 2017 +0200 2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql Mon Sep 25 14:30:02 2017 +0200 2.3 @@ -2720,7 +2720,7 @@ 2.4 SELECT "area_id" INTO "area_id_v" 2.5 FROM "issue" WHERE "id" = "issue_id_p"; 2.6 END IF; 2.7 - SELECT "unit_id" INTO "unit_id_v" FROM "area" WHERE "id" = "area_id_p"; 2.8 + SELECT "unit_id" INTO "unit_id_v" FROM "area" WHERE "id" = "area_id_v"; 2.9 INSERT INTO "snapshot" ("area_id", "issue_id") 2.10 VALUES ("area_id_v", "issue_id_p") 2.11 RETURNING "id" INTO "snapshot_id_v";