liquid_feedback_core

changeset 481:698559ebe9cd

Fixed wrong calculation of "leading" column
author jbe
date Fri Apr 01 17:01:30 2016 +0200 (2016-04-01)
parents bae6d7c89f97
children 75130c1d90da
files core.sql update/core-update.v3.1.0-v3.2.0.sql
line diff
     1.1 --- a/core.sql	Fri Apr 01 16:57:59 2016 +0200
     1.2 +++ b/core.sql	Fri Apr 01 17:01:30 2016 +0200
     1.3 @@ -2403,6 +2403,7 @@
     1.4      NOT EXISTS (
     1.5        SELECT NULL FROM "initiative" AS "better_initiative"
     1.6        WHERE
     1.7 +        "better_initiative"."issue_id" = "initiative"."issue_id" AND
     1.8          ("better_initiative"."harmonic_weight", -"better_initiative"."id") >
     1.9          ("initiative"."harmonic_weight", -"better_initiative"."id")
    1.10      ) AS "leading",
    1.11 @@ -2501,6 +2502,7 @@
    1.12      NOT EXISTS (
    1.13        SELECT NULL FROM "initiative" AS "better_initiative"
    1.14        WHERE
    1.15 +        "better_initiative"."issue_id" = "initiative"."issue_id" AND
    1.16          ("better_initiative"."harmonic_weight", -"better_initiative"."id") >
    1.17          ("initiative"."harmonic_weight", -"better_initiative"."id")
    1.18      ) AS "leading",
     2.1 --- a/update/core-update.v3.1.0-v3.2.0.sql	Fri Apr 01 16:57:59 2016 +0200
     2.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql	Fri Apr 01 17:01:30 2016 +0200
     2.3 @@ -46,6 +46,7 @@
     2.4      NOT EXISTS (
     2.5        SELECT NULL FROM "initiative" AS "better_initiative"
     2.6        WHERE
     2.7 +        "better_initiative"."issue_id" = "initiative"."issue_id" AND
     2.8          ("better_initiative"."harmonic_weight", -"better_initiative"."id") >
     2.9          ("initiative"."harmonic_weight", -"better_initiative"."id")
    2.10      ) AS "leading",
    2.11 @@ -144,6 +145,7 @@
    2.12      NOT EXISTS (
    2.13        SELECT NULL FROM "initiative" AS "better_initiative"
    2.14        WHERE
    2.15 +        "better_initiative"."issue_id" = "initiative"."issue_id" AND
    2.16          ("better_initiative"."harmonic_weight", -"better_initiative"."id") >
    2.17          ("initiative"."harmonic_weight", -"better_initiative"."id")
    2.18      ) AS "leading",

Impressum / About Us