cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michał Matłoka (JIRA) <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-11311) Delete of last row in the partition on table with static column returns row with nulls
Date Mon, 07 Mar 2016 11:52:40 GMT

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

Mime
View raw message