[CASSANDRA-6782] setting TTL on some columns seems to expire whole row

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.0.6

Environment

java version "1.7.0_51"
cassandra from trunk: 9c4824d6c476

• Severity: Normal
• Assignee: Sylvain Lebresne
• Reporter: Russ Hatch

Authors

Sylvain Lebresne

Reviewers

Aleksey Yeschenko

• Created: 27/Feb/14 22:53
• Updated: 16/Apr/19 09:31
• Resolved: 04/Mar/14 10:53

Description

I create a table with 4 columns, set a ttl on 2 of the columns and when the TTL is up, the entire row disappears.

cqlsh:myks> CREATE TABLE paging_test (
        ...   id int,
        ...   mytext text,
        ...   anothervalue text,
        ...   somevalue text,
        ...   PRIMARY KEY (id, mytext)
        ... );
cqlsh:myks> insert into paging_test (id, mytext, anothervalue, somevalue) values (1, 'foo', 'some', 'another');
cqlsh:myks> select * from paging_test;

 id | mytext | anothervalue | somevalue
----+--------+--------------+-----------
  1 |    foo |         some |   another

(1 rows)

cqlsh:myks> update paging_test using ttl 10
        ...   set somevalue='one', anothervalue='two'
        ...   where id = 1 and mytext = 'foo';
cqlsh:myks> select * from paging_test;

 id | mytext | anothervalue | somevalue
----+--------+--------------+-----------
  1 |    foo |          two |       one

(1 rows)

cqlsh:myks> -- wait for it....
cqlsh:myks> select * from paging_test;

(0 rows)

Issue Links

• is related to: CASSANDRA-8206 Deleting columns breaks secondary index on clustering column
• is related to: CASSANDRA-8147 Secondary indexing of map keys does not work properly when mixing contains and contains_key
• relates to: CASSANDRA-13127 Materialized Views: View row expires too soon
• relates to: CASSANDRA-8185 Removing the last item from a collection removes the entire row