I have a table created in cql :
create table isolation_demo(key text,column1 text,column2 text,column3 text ,primary key(key,column1,column2));
I have 2 statement in a batch.
update isolation_demo set column3 ='ABC' where key =1 and column1 =1 and column2=1;
delete from isolation_demo where key =1 and column1 =2 and column2=2;
here the both statements share same partition key. (key=1), but different clustering column values. Will these 2 statements be isolated?
These queries must be isolated, as mentioned in C* docs here and here: