liquid_feedback_core

diff update/core-update.v3.1.0-v3.2.0.sql @ 481:698559ebe9cd

find changesets by author, revision, files, or words in the commit message
Fixed wrong calculation of "leading" column
author jbe
date Fri Apr 01 17:01:30 2016 +0200 (2016-04-01)
parents bae6d7c89f97
children 75130c1d90da
line diff
     1.1 --- a/update/core-update.v3.1.0-v3.2.0.sql	Fri Apr 01 16:57:59 2016 +0200
     1.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql	Fri Apr 01 17:01:30 2016 +0200
     1.3 @@ -46,6 +46,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 @@ -144,6 +145,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",

Impressum / About Us