I meant more concrete cases. Say there is some weird behaviour and you suspect that it's due to a race condition. Maybe someone forgot to do "select for update

I meant more concrete cases. Say there is some weird behaviour and you suspect that it's due to a race condition. Maybe someone forgot to do "select for update" and you want to write a test to confirm. How to do that? Even if you know 100% that it's a race condition, you still might want to add a test to prevent it from happening again no?