[CASSANDRA-8558] deleted row still can be selected out

• Type: Bug
• Status: Resolved
• Priority: Urgent
• Resolution: Fixed
• Fix Version/s: 2.0.12, 2.1.3
• Labels: qa-resolved

Environment

2.1.2
java version "1.7.0_55"

• Severity: Critical
• Assignee: Sylvain Lebresne
• Reporter: zhaoyan

Authors

Sylvain Lebresne

Reviewers

Tom Hobbs

• Tester: Philip Thompson
• Created: 04/Jan/15 09:40
• Updated: 16/Apr/19 09:31
• Resolved: 14/Jan/15 11:14

Description

first

CREATE  KEYSPACE space1 WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 3};
CREATE  TABLE space1.table3(a int, b int, c text,primary key(a,b));
CREATE  KEYSPACE space2 WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 3};

second

CREATE  TABLE space2.table1(a int, b int, c int, primary key(a,b));
CREATE  TABLE space2.table2(a int, b int, c int, primary key(a,b));
INSERT INTO space1.table3(a,b,c) VALUES(1,1,'1');
drop table space2.table1;
DELETE FROM space1.table3 where a=1 and b=1;
drop table space2.table2;
select * from space1.table3 where a=1 and b=1;

you will find that the row (a=1 and b=1) in space1.table3 is not deleted.

Issue Links

• is duplicated by: CASSANDRA-10618 Read ghost data