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