The StepType IS NULL arm is not defensive clutter: StepType is nullable and rows predating the
column exist in real databases. A human task written before it would be invisible to a bare
StepType='Human' filter — asked, never settled, never expired, dead forever. This is the wide
form the reopen path already used; the settle and expiry paths were narrower, which is B4.
SQL for "a person completes this task".
The
StepType IS NULLarm is not defensive clutter:StepTypeis nullable and rows predating the column exist in real databases. A human task written before it would be invisible to a bareStepType='Human'filter — asked, never settled, never expired, dead forever. This is the wide form the reopen path already used; the settle and expiry paths were narrower, which is B4.