cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sylvain Lebresne (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-8042) Inconsistent static column behavior after row deletion
Date Fri, 03 Oct 2014 08:17:34 GMT

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

Sylvain Lebresne commented on CASSANDRA-8042:
---------------------------------------------

I don't see anything here that is not working as designed. If you include a static column
in an insert with a TTL, then this static column gets the TTL. So if you do:
{noformat}
insert into tt (c1, c2, c3, cs) VALUES ( '1', '1-3', 'x', 's3') USING TTL 20;
insert into tt (c1, c2, c3, cs) VALUES ( '1', '1-4', 'x', 's4') USING TTL 3;
{noformat}
you're setting a TTL of 20 seconds to the {{cs}} static column, and update that TTL to 3 seconds
right away. After 3 seconds, the static column (shared by all rows of the partition by definition)
will expire.

So I don't see a problem here but you might want to explain what you think is inconsistent
(by explaining what you would have expected to happen).

> Inconsistent static column behavior after row deletion
> ------------------------------------------------------
>
>                 Key: CASSANDRA-8042
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8042
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>            Reporter: viasyn
>             Fix For: 2.1.1
>
>
> I've a table with static column defined. I'm inserting some rows with TTL defined, then
one of row expires TTL of all the rows with same PK turns into null:
> {code}
> cqlsh:test> create table tt ( c1 text , c2 text , c3 text, cs text static, PRIMARY
KEY (c1, c2) );
> cqlsh:test> insert into tt (c1, c2, c3, cs) VALUES ( '1', '1-1', 'x', 's1') USING
TTL 10;
> cqlsh:test> insert into tt (c1, c2, c3, cs) VALUES ( '1', '1-2', 'x', 's2') USING
TTL 5;
> cqlsh:test> insert into tt (c1, c2, c3, cs) VALUES ( '1', '1-3', 'x', 's3') USING
TTL 20;
> cqlsh:test> insert into tt (c1, c2, c3, cs) VALUES ( '1', '1-4', 'x', 's4') USING
TTL 3;
> cqlsh:test> select * from tt;
>  c1 | c2  | cs | c3
> ----+-----+----+----
>   1 | 1-1 | s4 |  x
>   1 | 1-2 | s4 |  x
>   1 | 1-3 | s4 |  x
>   1 | 1-4 | s4 |  x
> (4 rows)
> cqlsh:test> select * from tt;
>  c1 | c2  | cs | c3
> ----+-----+----+----
>   1 | 1-1 | s4 |  x
>   1 | 1-2 | s4 |  x
>   1 | 1-3 | s4 |  x
>   1 | 1-4 | s4 |  x
> (4 rows)
> cqlsh:test> select * from tt;
>  c1 | c2  | cs   | c3
> ----+-----+------+----
>   1 | 1-1 | null |  x
>   1 | 1-2 | null |  x
>   1 | 1-3 | null |  x
> (3 rows)
> {code}
> Same scenario with manual DELETion leads to another result:
> {code}
> cqlsh:test> create table tt1 ( c1 text , c2 text , c3 text, cs text static, PRIMARY
KEY (c1, c2) );
> cqlsh:test> insert into tt1 (c1, c2, c3, cs) VALUES ( '1', '1-1', 'x', 's1');
> cqlsh:test> insert into tt1 (c1, c2, c3, cs) VALUES ( '1', '1-2', 'x', 's2');
> cqlsh:test> insert into tt1 (c1, c2, c3, cs) VALUES ( '1', '1-3', 'x', 's3');
> cqlsh:test> insert into tt1 (c1, c2, c3, cs) VALUES ( '1', '1-4', 'x', 's4');
> cqlsh:test> select * from tt1;
>  c1 | c2  | cs | c3
> ----+-----+----+----
>   1 | 1-1 | s4 |  x
>   1 | 1-2 | s4 |  x
>   1 | 1-3 | s4 |  x
>   1 | 1-4 | s4 |  x
> (4 rows)
> cqlsh:test> delete from tt1 WHERE c1='1' AND c2 = '1-2';
> cqlsh:test> select * from tt1;
>  c1 | c2  | cs | c3
> ----+-----+----+----
>   1 | 1-1 | s4 |  x
>   1 | 1-3 | s4 |  x
>   1 | 1-4 | s4 |  x
> (3 rows)
> cqlsh:test> delete from tt1 WHERE c1='1' AND c2 = '1-4';
> cqlsh:test> select * from tt1;
>  c1 | c2  | cs | c3
> ----+-----+----+----
>   1 | 1-1 | s4 |  x
>   1 | 1-3 | s4 |  x
> (2 rows)
> {code}
> Is this behavior bug or it's declared somewhere? Is it really good that deletion behavior
is inconsistent? 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message