[jira] [Commented] (CASSANDRA-11311) Delete of last row in the partition on table with static column returns row with nulls

["Benjamin Lerer (JIRA)" <ji...@apache.org>]

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

Benjamin Lerer commented on CASSANDRA-11311:
--------------------------------------------

This is the correct behavior (feature  :-)).
What you deleted is the rows from the partition not the static columns. Static columns are stored at the partition level not at the row level.



> Delete of last row in the partition on table with static column returns row with nulls
> --------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-11311
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11311
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: Cassandra 3.3
>            Reporter: Michał Matłoka
>
> {code}
> create table static_delete_test (
> 	id text,
> 	clustering text,
>         value int,
> 	sthstatic text static,
> 	PRIMARY KEY (id, clustering)
> );
> insert into static_delete_test(id, clustering, value, sthstatic) values ('a',  'd', 1, 'statica');
> insert into static_delete_test(id, clustering, value, sthstatic) values ('b',  'd', 2, 'staticb');
> insert into static_delete_test(id, clustering, value, sthstatic) values ('c',  'd', 3, 'staticc');
> delete from static_delete_test where id = 'a' and clustering = 'd';
> select * from static_delete_test;
> {code}
> returns
> {code}
> a,null,statica,null
> c,d,staticc,3
> b,d,staticb,2
> {code}
> Problem occurs only when last row in the partition is deleted; Or is it a feature?



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