[jira] [Created] (CASSANDRA-5200) Add a way to cancel TTL on a column (without changing value)

["Anentropic (JIRA)" <ji...@apache.org>]

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