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"

Impressum / About Us