liquid_feedback_core

changeset 140:c6a47e32b2fb

Bugfix in function "calculate_ranks": Use simple majorities for disqualification
author jbe
date Sun May 29 20:13:37 2011 +0200 (2011-05-29)
parents e3bfa2d7954c
children f21a0b10f8ed
files core.sql
line diff
     1.1 --- a/core.sql	Sun May 29 19:51:16 2011 +0200
     1.2 +++ b/core.sql	Sun May 29 20:13:37 2011 +0200
     1.3 @@ -3835,7 +3835,6 @@
     1.4            FROM (
     1.5              SELECT "losing_initiative"."id" AS "initiative_id"
     1.6              FROM "issue"
     1.7 -            JOIN "policy" ON "issue"."policy_id" = "policy"."id"
     1.8              JOIN "initiative" "losing_initiative"
     1.9                ON "losing_initiative"."issue_id" = "issue_id_p"
    1.10                AND "losing_initiative"."admitted"
    1.11 @@ -3865,15 +3864,7 @@
    1.12                ("winning_initiative"."id" ISNULL AND "losing_initiative"."unfavored") OR
    1.13                ( "winning_initiative"."preliminary_rank" <
    1.14                  "losing_initiative"."preliminary_rank" ) )
    1.15 -            AND CASE WHEN "policy"."majority_strict" THEN
    1.16 -              "battle_win"."count" * "policy"."majority_den" >
    1.17 -              "policy"."majority_num" *
    1.18 -              ("battle_win"."count"+"battle_lose"."count")
    1.19 -            ELSE
    1.20 -              "battle_win"."count" * "policy"."majority_den" >=
    1.21 -              "policy"."majority_num" *
    1.22 -              ("battle_win"."count"+"battle_lose"."count")
    1.23 -            END
    1.24 +            AND "battle_win"."count" > "battle_lose"."count"
    1.25            ) AS "subquery"
    1.26            WHERE "id" = "subquery"."initiative_id";
    1.27          -- calculate final ranks (start counting with 1, no equal ranks):

Impressum / About Us