# HG changeset patch
# User jbe
# Date 1506706669 -7200
# Node ID 622c71ca6428282a8dd06102a871204a4ed50148
# Parent  b1326d14924760c1fdd437191853806cb873532b
Bugfix in view "unit_member" (wrong ON clause for JOIN)

diff -r b1326d149247 -r 622c71ca6428 core.sql
--- a/core.sql	Fri Sep 29 01:57:43 2017 +0200
+++ b/core.sql	Fri Sep 29 19:37:49 2017 +0200
@@ -3465,7 +3465,7 @@
     "unit"."id"   AS "unit_id",
     "member"."id" AS "member_id"
   FROM "privilege"
-  JOIN "unit"   ON "unit_id"     = "privilege"."unit_id"
+  JOIN "unit"   ON "unit"."id"   = "privilege"."unit_id"
   JOIN "member" ON "member"."id" = "privilege"."member_id"
   WHERE "privilege"."voting_right" AND "member"."active";
 
diff -r b1326d149247 -r 622c71ca6428 update/core-update.v3.2.2-v4.0.0.sql
--- a/update/core-update.v3.2.2-v4.0.0.sql	Fri Sep 29 01:57:43 2017 +0200
+++ b/update/core-update.v3.2.2-v4.0.0.sql	Fri Sep 29 19:37:49 2017 +0200
@@ -2140,7 +2140,7 @@
     "unit"."id"   AS "unit_id",
     "member"."id" AS "member_id"
   FROM "privilege"
-  JOIN "unit"   ON "unit_id"     = "privilege"."unit_id"
+  JOIN "unit"   ON "unit"."id"   = "privilege"."unit_id"
   JOIN "member" ON "member"."id" = "privilege"."member_id"
   WHERE "privilege"."voting_right" AND "member"."active";