# HG changeset patch
# User jbe
# Date 1459522890 -7200
# Node ID 698559ebe9cdf5d8ff16487627c304ccaa132b0b
# Parent  bae6d7c89f97519a8959bd6fe1b7c5a58aed6e5f
Fixed wrong calculation of "leading" column

diff -r bae6d7c89f97 -r 698559ebe9cd core.sql
--- a/core.sql	Fri Apr 01 16:57:59 2016 +0200
+++ b/core.sql	Fri Apr 01 17:01:30 2016 +0200
@@ -2403,6 +2403,7 @@
     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")
     ) AS "leading",
@@ -2501,6 +2502,7 @@
     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")
     ) AS "leading",
diff -r bae6d7c89f97 -r 698559ebe9cd update/core-update.v3.1.0-v3.2.0.sql
--- a/update/core-update.v3.1.0-v3.2.0.sql	Fri Apr 01 16:57:59 2016 +0200
+++ b/update/core-update.v3.1.0-v3.2.0.sql	Fri Apr 01 17:01:30 2016 +0200
@@ -46,6 +46,7 @@
     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")
     ) AS "leading",
@@ -144,6 +145,7 @@
     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")
     ) AS "leading",