[CASSANDRA-6363] CAS not applied on rows containing an expired ttl column

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Cannot Reproduce
• Component/s: Feature/Lightweight Transactions, Legacy/Coordination
• Labels: LWT

Environment

Linux/x64 2.0.2 4-node cluster

• Severity: Normal
• Assignee: Stefania Alborghetti
• Reporter: Michał Ziemski

Authors

Stefania Alborghetti

• Created: 16/Nov/13 07:37
• Updated: 25/Oct/19 13:11
• Resolved: 30/Mar/15 07:22

Description

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.