[ 
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)

Reply via email to