[ https://issues.apache.org/jira/browse/CASSANDRA-4193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13402970#comment-13402970 ]
Sylvain Lebresne commented on CASSANDRA-4193: --------------------------------------------- It is relevant for the 1.1 branch (for which the patch is targeted) since CASSANDRA-3708 is 1.2 only. > cql delete does not delete > --------------------------- > > Key: CASSANDRA-4193 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4193 > Project: Cassandra > Issue Type: Bug > Affects Versions: 1.1.0 > Reporter: Jackson Chung > Assignee: Sylvain Lebresne > Labels: cql3 > Fix For: 1.1.2 > > Attachments: 4193.txt > > > tested in 1.1 and trunk branch on a single node: > {panel} > cqlsh:test> create table testcf_old ( username varchar , id int , name > varchar , stuff varchar, primary key(username,id,name)) with compact storage; > cqlsh:test> insert into testcf_old ( username , id , name , stuff ) values > ('abc', 2, 'rst', 'some other bunch of craps'); > cqlsh:test> select * from testcf_old; > username | id | name | stuff > ----------+----+------+--------------------------- > abc | 2 | rst | some other bunch of craps > abc | 4 | xyz | a bunch of craps > cqlsh:test> delete from testcf_old where username = 'abc' and id =2; > cqlsh:test> select * from testcf_old; > username | id | name | stuff > ----------+----+------+--------------------------- > abc | 2 | rst | some other bunch of craps > abc | 4 | xyz | a bunch of craps > {panel} > same also when not using compact: > {panel} > cqlsh:test> create table testcf ( username varchar , id int , name varchar , > stuff varchar, primary key(username,id)); > cqlsh:test> select * from testcf; > username | id | name | stuff > ----------+----+---------------------------+------------------ > abc | 2 | some other bunch of craps | rst > abc | 4 | xyz | a bunch of craps > cqlsh:test> delete from testcf where username = 'abc' and id =2; > cqlsh:test> select * from testcf; > username | id | name | stuff > ----------+----+---------------------------+------------------ > abc | 2 | some other bunch of craps | rst > abc | 4 | xyz | a bunch of craps > {panel} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira