[
https://issues.apache.org/jira/browse/CASSANDRA-6782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13916266#comment-13916266
]
Brandon Williams commented on CASSANDRA-6782:
---------------------------------------------
I have to agree, this syntax seems misleading.
> setting TTL on some columns seems to expire whole row
> -----------------------------------------------------
>
> Key: CASSANDRA-6782
> URL: https://issues.apache.org/jira/browse/CASSANDRA-6782
> Project: Cassandra
> Issue Type: Bug
> Environment: java version "1.7.0_51"
> cassandra from trunk: 9c4824d6c476
> Reporter: Russ Hatch
>
> 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.
> {noformat}
> 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)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
