liquid_feedback_core

diff core.sql @ 625:7f488033d5ee
Fixed mistake in last-level tie-breaking
author: jbe
date: Wed Jan 01 16:49:21 2025 +0100 (7 months ago)
parents: 5b7c4082d7b3
     1.1 --- a/core.sql	Fri Feb 05 13:50:45 2021 +0100
     1.2 +++ b/core.sql	Wed Jan 01 16:49:21 2025 +0100
     1.3 @@ -5851,11 +5851,11 @@
     1.4            CASE WHEN "initiative1_ord_p" < "initiative2_ord_p" THEN
     1.5              1::INT8 << 62
     1.6            ELSE 0 END
     1.7 -          +
     1.8 +          -
     1.9            CASE WHEN "tie_breaking_p" = 'variant2'::"tie_breaking" THEN
    1.10 -            ("initiative2_ord_p"::INT8 << 31) - "initiative1_ord_p"::INT8
    1.11 +            ("initiative2_ord_p"::INT8 << 31) + "initiative1_ord_p"::INT8
    1.12            ELSE
    1.13 -            "initiative2_ord_p"::INT8 - ("initiative1_ord_p"::INT8 << 31)
    1.14 +            ("initiative1_ord_p"::INT8 << 31) + "initiative2_ord_p"::INT8
    1.15            END
    1.16          END
    1.17        );