Use IMMEDIATE constraint check time by default

yay deterministic tests
Added a test with delayed constraint check time