Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Fri, 28 Feb 2014 20:28:19 +0000 (UTC)
From: "Sylvain Lebresne (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12697821.1393541584526.127183.1393619299974@arcas>
In-Reply-To: <JIRA.12697821.1393541584526@arcas>
References: <JIRA.12697821.1393541584526@arcas>
Subject: [jira] [Updated] (CASSANDRA-6782) setting TTL on some columns seems
 to expire whole row
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/CASSANDRA-6782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sylvain Lebresne updated CASSANDRA-6782:
----------------------------------------

    Attachment: 6782.txt

Ok, seems there is a relatively good agreement that this needs to change, so attaching trivial patch for that.

> 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
>             Fix For: 2.0.6
>
>         Attachments: 6782.txt
>
>
> 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)