# HG changeset patch
# User jbe
# Date 1359840378 -3600
# Node ID 89974afd890b59718f401eb779fead9dd7fca93f
# Parent  09e2805decd3097c06d5b81f8a1818965df3e3df
Bugfix in view "remaining_harmonic_opinion_weight"

diff -r 09e2805decd3 -r 89974afd890b core.sql
--- a/core.sql	Sat Feb 02 20:37:03 2013 +0100
+++ b/core.sql	Sat Feb 02 22:26:18 2013 +0100
@@ -3188,6 +3188,9 @@
       ("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
   GROUP BY
     "initiative"."issue_id",
     "opinion"."initiative_id",
diff -r 09e2805decd3 -r 89974afd890b update/core-update.v2.1.0-v2.1.1.sql
--- a/update/core-update.v2.1.0-v2.1.1.sql	Sat Feb 02 20:37:03 2013 +0100
+++ b/update/core-update.v2.1.0-v2.1.1.sql	Sat Feb 02 22:26:18 2013 +0100
@@ -141,6 +141,9 @@
       ("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
   GROUP BY
     "initiative"."issue_id",
     "opinion"."initiative_id",