# HG changeset patch
# User jbe
# Date 1459524272 -7200
# Node ID d264e48cffbffbdf650e19f9489881650c21b55d
# Parent  39f37c2a0c8503bc3bd10bb99280d86c7f9710d8
Sort harmonic_weight of NULL after zero in updated_or_featured_initiative

diff -r 39f37c2a0c85 -r d264e48cffbf core.sql
--- a/core.sql	Fri Apr 01 17:15:12 2016 +0200
+++ b/core.sql	Fri Apr 01 17:24:32 2016 +0200
@@ -2403,9 +2403,12 @@
     NOT EXISTS (
       SELECT NULL FROM "initiative" AS "better_initiative"
       WHERE
-        "better_initiative"."issue_id" = "initiative"."issue_id" AND
-        ("better_initiative"."harmonic_weight", -"better_initiative"."id") >
-        ("initiative"."harmonic_weight", -"better_initiative"."id")
+        "better_initiative"."issue_id" = "initiative"."issue_id"
+      AND
+        ( COALESCE("better_initiative"."harmonic_weight", -1),
+          -"better_initiative"."id" ) >
+        ( COALESCE("initiative"."harmonic_weight", -1),
+          -"better_initiative"."id" )
     ) AS "leading",
     "initiative".*
   FROM "member" CROSS JOIN "initiative"
@@ -2502,9 +2505,12 @@
     NOT EXISTS (
       SELECT NULL FROM "initiative" AS "better_initiative"
       WHERE
-        "better_initiative"."issue_id" = "initiative"."issue_id" AND
-        ("better_initiative"."harmonic_weight", -"better_initiative"."id") >
-        ("initiative"."harmonic_weight", -"better_initiative"."id")
+        "better_initiative"."issue_id" = "initiative"."issue_id"
+      AND
+        ( COALESCE("better_initiative"."harmonic_weight", -1),
+          -"better_initiative"."id" ) >
+        ( COALESCE("initiative"."harmonic_weight", -1),
+          -"better_initiative"."id" )
     ) AS "leading",
     "initiative".*
   FROM "member" CROSS JOIN "area"
diff -r 39f37c2a0c85 -r d264e48cffbf update/core-update.v3.1.0-v3.2.0.sql
--- a/update/core-update.v3.1.0-v3.2.0.sql	Fri Apr 01 17:15:12 2016 +0200
+++ b/update/core-update.v3.1.0-v3.2.0.sql	Fri Apr 01 17:24:32 2016 +0200
@@ -46,9 +46,12 @@
     NOT EXISTS (
       SELECT NULL FROM "initiative" AS "better_initiative"
       WHERE
-        "better_initiative"."issue_id" = "initiative"."issue_id" AND
-        ("better_initiative"."harmonic_weight", -"better_initiative"."id") >
-        ("initiative"."harmonic_weight", -"better_initiative"."id")
+        "better_initiative"."issue_id" = "initiative"."issue_id"
+      AND
+        ( COALESCE("better_initiative"."harmonic_weight", -1),
+          -"better_initiative"."id" ) >
+        ( COALESCE("initiative"."harmonic_weight", -1),
+          -"better_initiative"."id" )
     ) AS "leading",
     "initiative".*
   FROM "member" CROSS JOIN "initiative"
@@ -145,9 +148,12 @@
     NOT EXISTS (
       SELECT NULL FROM "initiative" AS "better_initiative"
       WHERE
-        "better_initiative"."issue_id" = "initiative"."issue_id" AND
-        ("better_initiative"."harmonic_weight", -"better_initiative"."id") >
-        ("initiative"."harmonic_weight", -"better_initiative"."id")
+        "better_initiative"."issue_id" = "initiative"."issue_id"
+      AND
+        ( COALESCE("better_initiative"."harmonic_weight", -1),
+          -"better_initiative"."id" ) >
+        ( COALESCE("initiative"."harmonic_weight", -1),
+          -"better_initiative"."id" )
     ) AS "leading",
     "initiative".*
   FROM "member" CROSS JOIN "area"