Chandra Sekar created CASSANDRA-9842:
----------------------------------------

             Summary: 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)

Reply via email to