# HG changeset patch
# User jbe
# Date 1359840715 -3600
# Node ID 685d38986598527daa2fad591efadfd5c40ece21
# Parent  89974afd890b59718f401eb779fead9dd7fca93f
Bugfix in view "remaining_harmonic_suggestion_weight_summands"

diff -r 89974afd890b -r 685d38986598 core.sql
--- a/core.sql	Sat Feb 02 22:26:18 2013 +0100
+++ b/core.sql	Sat Feb 02 22:31:55 2013 +0100
@@ -3210,6 +3210,10 @@
   JOIN "opinion"
     ON "remaining_harmonic_opinion_weight"."initiative_id" = "opinion"."initiative_id"
     AND "remaining_harmonic_opinion_weight"."member_id" = "opinion"."member_id"
+    AND (
+      ("opinion"."degree" > 0 AND "opinion"."fulfilled" = FALSE) OR
+      ("opinion"."degree" < 0 AND "opinion"."fulfilled" = TRUE)
+    )
   JOIN "suggestion"
     ON "opinion"."suggestion_id" = "suggestion"."id"
     AND "suggestion"."harmonic_weight" ISNULL
diff -r 89974afd890b -r 685d38986598 update/core-update.v2.1.0-v2.1.1.sql
--- a/update/core-update.v2.1.0-v2.1.1.sql	Sat Feb 02 22:26:18 2013 +0100
+++ b/update/core-update.v2.1.0-v2.1.1.sql	Sat Feb 02 22:31:55 2013 +0100
@@ -162,6 +162,10 @@
   JOIN "opinion"
     ON "remaining_harmonic_opinion_weight"."initiative_id" = "opinion"."initiative_id"
     AND "remaining_harmonic_opinion_weight"."member_id" = "opinion"."member_id"
+    AND (
+      ("opinion"."degree" > 0 AND "opinion"."fulfilled" = FALSE) OR
+      ("opinion"."degree" < 0 AND "opinion"."fulfilled" = TRUE)
+    )
   JOIN "suggestion"
     ON "opinion"."suggestion_id" = "suggestion"."id"
     AND "suggestion"."harmonic_weight" ISNULL