Prasad created CASSANDRA-14144:
----------------------------------
Summary: Weird behaviour of TTL after update of a row
Key: CASSANDRA-14144
URL: https://issues.apache.org/jira/browse/CASSANDRA-14144
Project: Cassandra
Issue Type: Bug
Components: Core, CQL
Reporter: Prasad
Priority: Minor
Hi,
Cassandra Version: 2.2.10
Table Creation
cqlsh> create table key.ttltest( id int, message text, primary key(id));
cqlsh> insert into key.ttltest(id, message) values(1, 'first message') using
ttl 300;
cqlsh> select id, message, ttl(message) from key.ttltest;
id | message | ttl(message)
----+---------------+--------------
1 | first message | 280
cqlsh> select id, message, ttl(message) from key.ttltest;
id | message | ttl(message)
----+----------------+--------------
1 | first message | 234
2 | second message | 294
cqlsh> update key.ttltest using ttl 20 set message='hai' where id=1;
cqlsh> select id, message, ttl(message) from key.ttltest;
id | message | ttl(message)
----+----------------+--------------
1 | hai | 16
2 | second message | 215
cqlsh> select id, message, ttl(message) from key.ttltest;
id | message | ttl(message)
----+----------------+--------------
1 | null | null
2 | second message | 180
After 20 sec it's setting message as null, but as of my understanding after 20
sec the entire row should be deleted (because i am setting ttl for all columns
apart from partition key column ), but it's holding the data more time
approximately 200 sec
Other way is it's deleting the row after 300 sec i.e TTL being used for
insertion
is this is the expected behaviour ? why it's not deleting entire row after
completion of update TTL
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
