Anentropic created CASSANDRA-5200:
-------------------------------------

             Summary: Add a way to cancel TTL on a column (without changing 
value)
                 Key: CASSANDRA-5200
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5200
             Project: Cassandra
          Issue Type: New Feature
            Reporter: Anentropic


Currently you can set TTL on a column value:

    UPDATE table USING TTL 30 SET col1='test' WHERE id=123;

The only way to cancel the TTL, so that col1='test' doesn't expire, is to set 
col1 to a new value.

If you want col1 to keep its current value but stop expiring I don't see a 
reliable way. You (understandably) can't do:

    UPDATE table SET col1=col1 WHERE id=123;

And obviously if you have to SELECT the value first you have a race condition.

I understand the reasons for not allowing SET col1=col1 but I'm guessing it 
wouldn't be too hard to allow some way to cancel the TTL without having to set 
a value?

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to