[jira] [Commented] (CASSANDRA-9842) Creation of partition and update of static columns in the same LWT fails

["Chandra Sekar (JIRA)" <ji...@apache.org>]

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

Chandra Sekar commented on CASSANDRA-9842:
------------------------------------------

Yes, but in the first example, the "if" clause does say "if scol = null" and yet the batch fails.

> Creation of partition and update of static columns in the same LWT fails
> ------------------------------------------------------------------------
>
>                 Key: CASSANDRA-9842
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9842
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>         Environment: cassandra-2.1.8 on Ubuntu 15.04
>            Reporter: Chandra Sekar
>
> 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)