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",