cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex Petrov (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-9842) Inconsistent behavior for '= null' conditions on static columns
Date Sat, 09 Apr 2016 11:33:25 GMT

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

Alex Petrov edited comment on CASSANDRA-9842 at 4/9/16 11:33 AM:
-----------------------------------------------------------------

To sum up, there's no distinction between the non-existing row and a static column containing
{{null}} value, so both an update to non-existing row and row with null in static column will
succeed. 

Inconsistent behaviour is only in {{2.1}} and {{2.2}}, although I've added same tests to {{3.0}}
and {{trunk}}. 

|| ||2.1||2.2||3.0||trunk|
||code|[2.1|https://github.com/ifesdjeen/cassandra/tree/9842-2.1]|[2.2|https://github.com/ifesdjeen/cassandra/tree/9842-2.2]|[3.0|https://github.com/ifesdjeen/cassandra/tree/9842-3.0]|[trunk|https://github.com/ifesdjeen/cassandra/tree/9842-trunk]|
||utest|[2.1|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-2.1-testall/]|[2.2|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-2.2-testall/]|[3.0|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-3.0-testall/]|[trunk|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-trunk-testall/]|
||dtest|[2.1|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-2.1-dtest/]|[2.2|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-2.2-dtest/]|[3.0|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-3.0-dtest/]|[trunk|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-trunk-dtest/]|

Waiting for CI results.


was (Author: ifesdjeen):
To sum up, there's no distinction between the non-existing row and a static column containing
{{null}} value, so both an update to non-existing row and row with null in static column will
succeed. 

Inconsistent behaviour is only in {{2.1}} and {{2.2}}, although I've added same tests to {{3.0}}
and {{trunk}}. 

|_|2.1|2.2|3.0|trunk|
|code|[2.1|https://github.com/ifesdjeen/cassandra/tree/9842-2.1]|[2.2|https://github.com/ifesdjeen/cassandra/tree/9842-2.2]|[3.0|https://github.com/ifesdjeen/cassandra/tree/9842-3.0]|[trunk|https://github.com/ifesdjeen/cassandra/tree/9842-trunk]|
|utest|[2.1|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-2.1-testall/]|[2.2|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-2.2-testall/]|[3.0|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-3.0-testall/]|[trunk|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-trunk-testall/]|
|dtest|[2.1|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-2.1-dtest/]|[2.2|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-2.2-dtest/]|[3.0|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-3.0-dtest/]|[trunk|https://cassci.datastax.com/view/Dev/view/ifesdjeen/job/ifesdjeen-9842-trunk-dtest/]|

Waiting for CI results.

> Inconsistent behavior for '= null' conditions on static columns
> ---------------------------------------------------------------
>
>                 Key: CASSANDRA-9842
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9842
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: cassandra-2.1.8 on Ubuntu 15.04
>            Reporter: Chandra Sekar
>            Assignee: Alex Petrov
>             Fix For: 2.1.x, 2.2.x, 3.0.x, 3.x
>
>
> Both inserting a row (in a non-existent partition) and updating a static column in the
same LWT fails. Creating the partition before performing the LWT works.
> h3. Table Definition
> {code}
> create table txtable(pcol bigint, ccol bigint, scol bigint static, ncol text, primary
key((pcol), ccol));
> {code}
> h3. Inserting row in non-existent partition and updating static column in one LWT
> {code}
> begin batch
>     insert into txtable (pcol, ccol, ncol) values (1, 1, 'A');
>     update txtable set scol = 1 where pcol = 1 if scol = null;
> apply batch;
> [applied]
> -----------
>      False
> {code}
> h3. Creating partition before LWT
> {code}
> insert into txtable (pcol, scol) values (1, null) if not exists;
> begin batch
>     insert into txtable (pcol, ccol, ncol) values (1, 1, 'A');
>     update txtable set scol = 1 where pcol = 1 if scol = null;
> apply batch;
> [applied]
> -----------
>      True
> {code}



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

Mime
View raw message