cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Benjamin Lerer (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-13130) Strange result of several list updates in a single request
Date Thu, 16 Feb 2017 16:59:41 GMT

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

Benjamin Lerer commented on CASSANDRA-13130:
--------------------------------------------

There is clearly a bug. The {{7}} should not appear.
At the same time you should be carefull with those type of queries. When you issue a single
query with two updates, the two updates are  actually having the same timestamp which means
that the update with the higher value will win. As if you had send 2 {{UPDATE}} queries with
exactly the same timestamp.

So, {code}UPDATE t SET listColumn[2] = 8, listColumn[2] = 7  WHERE id = 1;{code} should also
return {{listColumn=(1,2,8,4)}}.

> Strange result of several list updates in a single request
> ----------------------------------------------------------
>
>                 Key: CASSANDRA-13130
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-13130
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Mikhail Krupitskiy
>            Assignee: Benjamin Lerer
>            Priority: Trivial
>
> Let's assume that we have a row with the 'listColumn' column and value \{1,2,3,4\}.
> For me it looks logical to expect that the following two pieces of code will ends up
with the same result but it isn't so.
> Code1:
> {code}
> UPDATE t SET listColumn[2] = 7, listColumn[2] = 8  WHERE id = 1;
> {code}
> Expected result: listColumn=\{1,2,8,4\} 
> Actual result: listColumn=\{1,2,7,8,4\}
> Code2:
> {code}
> UPDATE t SET listColumn[2] = 7  WHERE id = 1;
> UPDATE t SET listColumn[2] = 8  WHERE id = 1;
> {code}
> Expected result: listColumn=\{1,2,8,4\} 
> Actual result: listColumn=\{1,2,8,4\}
> So the question is why Code1 and Code2 give different results?
> Looks like Code1 should give the same result as Code2.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message