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

Impressum / About Us