The doc says:
Lightweight transactions use a timestamping mechanism different from normal operations, so mixing lightweight transactions and normal operations can result in errors. If lightweight transactions are used to write to a row within a partition, only lightweight transactions for both read and write operations should be used. This caution applies to all operations, whether individual or batched. For example, the following series of operations can fail: DELETE ... INSERT .... IF NOT EXISTS SELECT .... The following series of operations will work: DELETE ... IF EXISTS INSERT .... IF NOT EXISTS SELECT ...
Does it mean
insert into compain(id, day) values(1,1) if not exists; delete from compain where id = 1 insert into compain(id, day) values(1,1) if not exists;
No matter whether in a batch or not, the 2nd insert will not be applied? Why delete is not visible to the 2nd insert?
Why does using different timestamping mechanisms result in errors? And what kind of errors?