liquid_feedback_core

changeset 569:622c71ca6428

Bugfix in view "unit_member" (wrong ON clause for JOIN)
author jbe
date Fri Sep 29 19:37:49 2017 +0200 (2017-09-29)
parents b1326d149247
children 4c40333dac66
files core.sql update/core-update.v3.2.2-v4.0.0.sql
line diff
     1.1 --- a/core.sql	Fri Sep 29 01:57:43 2017 +0200
     1.2 +++ b/core.sql	Fri Sep 29 19:37:49 2017 +0200
     1.3 @@ -3465,7 +3465,7 @@
     1.4      "unit"."id"   AS "unit_id",
     1.5      "member"."id" AS "member_id"
     1.6    FROM "privilege"
     1.7 -  JOIN "unit"   ON "unit_id"     = "privilege"."unit_id"
     1.8 +  JOIN "unit"   ON "unit"."id"   = "privilege"."unit_id"
     1.9    JOIN "member" ON "member"."id" = "privilege"."member_id"
    1.10    WHERE "privilege"."voting_right" AND "member"."active";
    1.11  
     2.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Fri Sep 29 01:57:43 2017 +0200
     2.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Fri Sep 29 19:37:49 2017 +0200
     2.3 @@ -2140,7 +2140,7 @@
     2.4      "unit"."id"   AS "unit_id",
     2.5      "member"."id" AS "member_id"
     2.6    FROM "privilege"
     2.7 -  JOIN "unit"   ON "unit_id"     = "privilege"."unit_id"
     2.8 +  JOIN "unit"   ON "unit"."id"   = "privilege"."unit_id"
     2.9    JOIN "member" ON "member"."id" = "privilege"."member_id"
    2.10    WHERE "privilege"."voting_right" AND "member"."active";
    2.11  

Impressum / About Us