[
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)
