cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "zhaoyan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-8558) deleted row stiil can select out
Date Sun, 04 Jan 2015 09:40:34 GMT
zhaoyan created CASSANDRA-8558:
----------------------------------

             Summary: deleted row stiil can select out
                 Key: CASSANDRA-8558
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8558
             Project: Cassandra
          Issue Type: Bug
          Components: Core
         Environment: 2.1.2 
java version "1.7.0_55"
            Reporter: zhaoyan


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.



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

Mime
View raw message