liquid_feedback_core

diff update/core-update.v3.2.2-v4.0.0.sql @ 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
line diff
     1.1 --- a/update/core-update.v3.2.2-v4.0.0.sql	Fri Sep 29 01:57:43 2017 +0200
     1.2 +++ b/update/core-update.v3.2.2-v4.0.0.sql	Fri Sep 29 19:37:49 2017 +0200
     1.3 @@ -2140,7 +2140,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  

Impressum / About Us