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

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

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

Jonathan Ellis updated CASSANDRA-5200:
--------------------------------------

    Priority: Minor  (was: Major)
      Labels: ponies  (was: )

> 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
>            Priority: Minor
>              Labels: ponies
>
> 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 was sent by Atlassian JIRA
(v6.1#6144)