[
https://issues.apache.org/jira/browse/CASSANDRA-11311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Michał Matłoka updated CASSANDRA-11311:
---------------------------------------
Description:
{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;
was:
{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;
> 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;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
