Hi, I am trying to understand this error message that CQL is throwing when I try to update 2 different rows with different values on same conditional columns. Doesn't CQL support that? I am wondering why CQL has this restriction (since condition applies to each row independently, why does CQL even care if the values of the condition is same or different).
BEGIN BATCH UPDATE activities SET state='CLAIMED',version=11 WHERE key='Key1' IF version=10; UPDATE activities SET state='ALLOCATED',version=2 WHERE key='Key2' IF version=1; APPLY BATCH; gives the following error Bad Request: Duplicate and incompatible conditions for column version Is there anyway to update more than 1 row with different conditional value for each row (other than executing these statements individually)? -Praveen