Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-6782

setting TTL on some columns seems to expire whole row

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Fix Version/s: 2.0.6
    • Component/s: None
    • Labels:
      None
    • Environment:

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

    • Severity:
      Normal

      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)
      

        Attachments

        1. 6782.txt
          2 kB
          Sylvain Lebresne

          Issue Links

            Activity

              People

              • Assignee:
                slebresne Sylvain Lebresne
                Reporter:
                rhatch Russ Hatch
                Authors:
                Sylvain Lebresne
                Reviewers:
                Aleksey Yeschenko
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: