liquid_feedback_core
changeset 484:d264e48cffbf
Sort harmonic_weight of NULL after zero in updated_or_featured_initiative
author | jbe |
---|---|
date | Fri Apr 01 17:24:32 2016 +0200 (2016-04-01) |
parents | 39f37c2a0c85 |
children | e431f1b73c35 |
files | core.sql update/core-update.v3.1.0-v3.2.0.sql |
line diff
1.1 --- a/core.sql Fri Apr 01 17:15:12 2016 +0200 1.2 +++ b/core.sql Fri Apr 01 17:24:32 2016 +0200 1.3 @@ -2403,9 +2403,12 @@ 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 + "better_initiative"."issue_id" = "initiative"."issue_id" 1.11 + AND 1.12 + ( COALESCE("better_initiative"."harmonic_weight", -1), 1.13 + -"better_initiative"."id" ) > 1.14 + ( COALESCE("initiative"."harmonic_weight", -1), 1.15 + -"better_initiative"."id" ) 1.16 ) AS "leading", 1.17 "initiative".* 1.18 FROM "member" CROSS JOIN "initiative" 1.19 @@ -2502,9 +2505,12 @@ 1.20 NOT EXISTS ( 1.21 SELECT NULL FROM "initiative" AS "better_initiative" 1.22 WHERE 1.23 - "better_initiative"."issue_id" = "initiative"."issue_id" AND 1.24 - ("better_initiative"."harmonic_weight", -"better_initiative"."id") > 1.25 - ("initiative"."harmonic_weight", -"better_initiative"."id") 1.26 + "better_initiative"."issue_id" = "initiative"."issue_id" 1.27 + AND 1.28 + ( COALESCE("better_initiative"."harmonic_weight", -1), 1.29 + -"better_initiative"."id" ) > 1.30 + ( COALESCE("initiative"."harmonic_weight", -1), 1.31 + -"better_initiative"."id" ) 1.32 ) AS "leading", 1.33 "initiative".* 1.34 FROM "member" CROSS JOIN "area"
2.1 --- a/update/core-update.v3.1.0-v3.2.0.sql Fri Apr 01 17:15:12 2016 +0200 2.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql Fri Apr 01 17:24:32 2016 +0200 2.3 @@ -46,9 +46,12 @@ 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 + "better_initiative"."issue_id" = "initiative"."issue_id" 2.11 + AND 2.12 + ( COALESCE("better_initiative"."harmonic_weight", -1), 2.13 + -"better_initiative"."id" ) > 2.14 + ( COALESCE("initiative"."harmonic_weight", -1), 2.15 + -"better_initiative"."id" ) 2.16 ) AS "leading", 2.17 "initiative".* 2.18 FROM "member" CROSS JOIN "initiative" 2.19 @@ -145,9 +148,12 @@ 2.20 NOT EXISTS ( 2.21 SELECT NULL FROM "initiative" AS "better_initiative" 2.22 WHERE 2.23 - "better_initiative"."issue_id" = "initiative"."issue_id" AND 2.24 - ("better_initiative"."harmonic_weight", -"better_initiative"."id") > 2.25 - ("initiative"."harmonic_weight", -"better_initiative"."id") 2.26 + "better_initiative"."issue_id" = "initiative"."issue_id" 2.27 + AND 2.28 + ( COALESCE("better_initiative"."harmonic_weight", -1), 2.29 + -"better_initiative"."id" ) > 2.30 + ( COALESCE("initiative"."harmonic_weight", -1), 2.31 + -"better_initiative"."id" ) 2.32 ) AS "leading", 2.33 "initiative".* 2.34 FROM "member" CROSS JOIN "area"