You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Sylvain Lebresne (JIRA)" <ji...@apache.org> on 2012/04/27 15:15:48 UTC
[jira] [Updated] (CASSANDRA-4193) cql delete does not delete
[ https://issues.apache.org/jira/browse/CASSANDRA-4193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sylvain Lebresne updated CASSANDRA-4193:
----------------------------------------
Attachment: 4193.txt
> 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.1
>
> 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