# HG changeset patch
# User jbe
# Date 1306692817 -7200
# Node ID c6a47e32b2fb6e548b04a0cb464f2d5ed644d25c
# Parent  e3bfa2d7954cd294f67df806b1894b516e04936c
Bugfix in function "calculate_ranks": Use simple majorities for disqualification

diff -r e3bfa2d7954c -r c6a47e32b2fb core.sql
--- a/core.sql	Sun May 29 19:51:16 2011 +0200
+++ b/core.sql	Sun May 29 20:13:37 2011 +0200
@@ -3835,7 +3835,6 @@
           FROM (
             SELECT "losing_initiative"."id" AS "initiative_id"
             FROM "issue"
-            JOIN "policy" ON "issue"."policy_id" = "policy"."id"
             JOIN "initiative" "losing_initiative"
               ON "losing_initiative"."issue_id" = "issue_id_p"
               AND "losing_initiative"."admitted"
@@ -3865,15 +3864,7 @@
               ("winning_initiative"."id" ISNULL AND "losing_initiative"."unfavored") OR
               ( "winning_initiative"."preliminary_rank" <
                 "losing_initiative"."preliminary_rank" ) )
-            AND CASE WHEN "policy"."majority_strict" THEN
-              "battle_win"."count" * "policy"."majority_den" >
-              "policy"."majority_num" *
-              ("battle_win"."count"+"battle_lose"."count")
-            ELSE
-              "battle_win"."count" * "policy"."majority_den" >=
-              "policy"."majority_num" *
-              ("battle_win"."count"+"battle_lose"."count")
-            END
+            AND "battle_win"."count" > "battle_lose"."count"
           ) AS "subquery"
           WHERE "id" = "subquery"."initiative_id";
         -- calculate final ranks (start counting with 1, no equal ranks):