[
https://issues.apache.org/jira/browse/CASSANDRA-9842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sylvain Lebresne updated CASSANDRA-9842:
----------------------------------------
Assignee: Alex Petrov (was: Benjamin Lerer)
> 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)
