[jira] [Commented] (CASSANDRA-6801) INSERT with IF NOT EXISTS fails when row is an expired ttl

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

    [ https://issues.apache.org/jira/browse/CASSANDRA-6801?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13921298#comment-13921298 ] 

Paul Kendall commented on CASSANDRA-6801:
-----------------------------------------

This is related to CASSANDRA-6623. Although in that case only a single value has a TTL, in this all values have a TTL.


> INSERT with IF NOT EXISTS fails when row is an expired ttl
> ----------------------------------------------------------
>
>                 Key: CASSANDRA-6801
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6801
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: Adam Hattrell
>
> I ran this on a 2 DC cluster with 3 nodes each.  
> CREATE KEYSPACE test WITH replication = {
> 'class': 'NetworkTopologyStrategy',
> 'DC1': '3',
> 'DC2': '3'
> };
> CREATE TABLE clusterlock (
> name text,
> hostname text,
> lockid text,
> PRIMARY KEY (name)
> ) ;
> Then add some data and flush it to ensure the sstables exist (didn't reproduce in memtables for some reason).
> Then
>  insert into clusterlock (name, lockid, hostname) values  ( 'adam', 'tt', '111') IF NOT EXISTS USING TTL 5;
> Wait for ttl to be reached then try again:
>  insert into clusterlock (name, lockid, hostname) values  ( 'adam', 'tt', '111') IF NOT EXISTS USING TTL 5;
>  
> [applied]
> -----------
>      False
> select * shows no rows in table.



--
This message was sent by Atlassian JIRA
(v6.2#6252)