liquid_feedback_core
diff core.sql @ 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 |
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",