Fixed #33895 -- Fixed Case() crash with filters that match everything in When().
PR #15930 ↗ · django/django · · merged Aug 9, 2022 · +15−0 · base 63884829acd2
Agent prompt
what a new run launched now would send
Case() crashes with ~Q(pk__in=[]).
Description
The following code generates a syntax error.
User.objects.annotate(
_a=Case(
When(~Q(pk__in=[]), then=Value(True)),
default=Value(False),
output_field=BooleanField(),
)
).order_by("-a").values("pk")
The error is:
ProgrammingError: syntax error at or near "THEN"
LINE 1: ..._user"."id" FROM "users_user" ORDER BY CASE WHEN THEN true ...
The generated SQL is:
SELECT "users_user"."id" FROM "users_user" ORDER BY CASE WHEN THEN True ELSE False END ASC
I expected behavior to annotate all rows with the value True since they all match.
Relevant because ~Q(pkin=[]) is a sentinel value that is sometimes returned by application code.
Work only inside this repository checkout. Make the code change the task
describes, keeping the diff focused — no drive-by refactors.
When you are done, leave your changes committed or in the working tree;
they are collected automatically.
Stay on this snapshot checkout (`task/ycb_django_pr15930`). Never checkout, pull, or rebase onto `main`. That branch is a README-only orphan.
Stay on this HEAD. Do not fetch another default branch. Push only on the Cursor-created `crazy-cursor/…` side branch from this HEAD.
Some past runs of this task were launched with a different prompt (the prompt template changed since, or those runs predate this benchmark's stored prompt). Each run persists the exact prompt it sent at launch — that per-launch record is the audit trail; this page shows only the current one.
Reference diff
The task PR's merged diff — the judge's comparison target.