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