liquid_feedback_core

diff update/core-update.v3.2.2-v4.0.0.sql @ 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
     1.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Mon Sep 25 14:20:07 2017 +0200
     1.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Mon Sep 25 14:30:02 2017 +0200
     1.3 @@ -2720,7 +2720,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";