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):