Clarify delete CAS behavior

(Status: WIP)

This patch adds a test to better define the correct behavior for using the `ScanCAS()` API to conditionally delete rows. Initially it is expected that the test will fail, because we still need to find out what the correct behavior is.