[ https://issues.apache.org/jira/browse/CASSANDRA-6363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13824493#comment-13824493 ]
Michał Ziemski commented on CASSANDRA-6363: ------------------------------------------- My bad copiying the test case. :( In all the cases there should be id='abc' (we're working with one row only) insert into session (id, usr) values ('abc', 'abc'); update session using ttl 1 set valid = 1 where id = 'abc'; delete from session where id = 'abc' if usr ='abc'; The abowe yields: [applied] | usr ----------+---- False | abc update session set valid = null where id = 'abc'; delete from session where id = 'abc if usr ='abc'; The above actually works. > CAS not applied on rows containing an expired ttl column > -------------------------------------------------------- > > Key: CASSANDRA-6363 > URL: https://issues.apache.org/jira/browse/CASSANDRA-6363 > Project: Cassandra > Issue Type: Bug > Components: Core > Environment: Linux/x64 2.0.2 4-node cluster > Reporter: Michał Ziemski > > CREATE TABLE session ( > id text, > usr text, > valid int, > PRIMARY KEY (id) > ); > insert into session (id, usr) values ('abc', 'abc'); > update session using ttl 1 set valid = 1 where id = 'abc'; > (wait 1 sec) > And > delete from session where id = 'DSYUCTCLSOEKVLAQWNWYLVQMEQGGXD' if usr > ='demo'; > Yields: > [applied] | usr > -----------+----- > False | abc > Rather than applying the delete. > Executing: > update session set valid = null where id = 'abc'; > and again > delete from session where id = 'DSYUCTCLSOEKVLAQWNWYLVQMEQGGXD' if usr > ='demo'; > Positively deletes the row. -- This message was sent by Atlassian JIRA (v6.1#6144)