Skip to content

When changing the code in contest format nothing happens #2412

@eljosco

Description

@eljosco

in AtCoder contest format I'm change judge/contest_format/atcoder.py from
with connection.cursor() as cursor: cursor.execute(f""" SELECT MAX(cs.points) asscore, ( SELECT MIN(csub.date) FROM judge_contestsubmission ccs LEFT OUTER JOIN judge_submission csub ON (csub.id = ccs.submission_id) WHERE ccs.problem_id = cp.id AND ccs.participation_id = %s AND ccs.points = MAX(cs.points) ) AS time, cp.id AS probFROM judge_contestproblem cp INNER JOIN judge_contestsubmission cs ON (cs.problem_id = cp.id AND cs.participation_id = %s) LEFT OUTER JOIN judge_submission sub ON (sub.id = cs.submission_id) GROUP BY cp.id """, (participation.id, participation.id))
to

with connection.cursor() as cursor: cursor.execute(f""" SELECT MIN(cs.points) asscore, ( SELECT MIN(csub.date) FROM judge_contestsubmission ccs LEFT OUTER JOIN judge_submission csub ON (csub.id = ccs.submission_id) WHERE ccs.problem_id = cp.id AND ccs.participation_id = %s AND ccs.points = MIN(cs.points) ) AS time, cp.id AS probFROM judge_contestproblem cp INNER JOIN judge_contestsubmission cs ON (cs.problem_id = cp.id AND cs.participation_id = %s) LEFT OUTER JOIN judge_submission sub ON (sub.id = cs.submission_id) GROUP BY cp.id """, (participation.id, participation.id))

to get submission with a minimum number of points in leader board.
But I still see in the leaderboard that users have submission with the maximum number of points.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions