# HG changeset patch
# User jbe
# Date 1506342602 -7200
# Node ID c3931054bb554f9bbfaebbff16ecea0174b3b7de
# Parent  fb2663ca1e6b2ea76d1ff90afc6625460723f655
Bugfix in "take_snapshot" function when determining unit_id

diff -r fb2663ca1e6b -r c3931054bb55 core.sql
--- a/core.sql	Mon Sep 25 14:20:07 2017 +0200
+++ b/core.sql	Mon Sep 25 14:30:02 2017 +0200
@@ -4942,7 +4942,7 @@
         SELECT "area_id" INTO "area_id_v"
           FROM "issue" WHERE "id" = "issue_id_p";
       END IF;
-      SELECT "unit_id" INTO "unit_id_v" FROM "area" WHERE "id" = "area_id_p";
+      SELECT "unit_id" INTO "unit_id_v" FROM "area" WHERE "id" = "area_id_v";
       INSERT INTO "snapshot" ("area_id", "issue_id")
         VALUES ("area_id_v", "issue_id_p")
         RETURNING "id" INTO "snapshot_id_v";
diff -r fb2663ca1e6b -r c3931054bb55 update/core-update.v3.2.2-v4.0.0.sql
--- a/update/core-update.v3.2.2-v4.0.0.sql	Mon Sep 25 14:20:07 2017 +0200
+++ b/update/core-update.v3.2.2-v4.0.0.sql	Mon Sep 25 14:30:02 2017 +0200
@@ -2720,7 +2720,7 @@
         SELECT "area_id" INTO "area_id_v"
           FROM "issue" WHERE "id" = "issue_id_p";
       END IF;
-      SELECT "unit_id" INTO "unit_id_v" FROM "area" WHERE "id" = "area_id_p";
+      SELECT "unit_id" INTO "unit_id_v" FROM "area" WHERE "id" = "area_id_v";
       INSERT INTO "snapshot" ("area_id", "issue_id")
         VALUES ("area_id_v", "issue_id_p")
         RETURNING "id" INTO "snapshot_id_v";