Jackson Chung created CASSANDRA-4193:
----------------------------------------
Summary: cql delete does not delete
Key: CASSANDRA-4193
URL: https://issues.apache.org/jira/browse/CASSANDRA-4193
Project: Cassandra
Issue Type: Bug
Reporter: Jackson Chung
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
