[
https://issues.apache.org/jira/browse/CASSANDRA-3645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleksandr Shyshko updated CASSANDRA-3645:
-----------------------------------------
Description:
Edit: this is probably not a bug, but standard ghost/deletion behavior.
Reproduce by:
==================================================
cqlsh> CREATE KEYSPACE ss WITH strategy_class = 'SimpleStrategy' AND
strategy_options:replication_factor = 1;
cqlsh> use ss;
cqlsh:ss> create columnfamily users (name text primary key, pass text);
cqlsh:ss> select * from users;
cqlsh:ss> insert into users (name, pass) values ('john', 'secret');
cqlsh:ss> select * from users;
name | pass |
john | secret |
cqlsh:ss> delete from users where name = 'john';
cqlsh:ss> select * from users;
name |
john |
cqlsh:ss>
==================================================
Desired behavior:
==================================================
cqlsh:ss> delete from users where name = 'john';
cqlsh:ss> select * from users;
cqlsh:ss>
==================================================
was:
Reproduce by:
==================================================
cqlsh> CREATE KEYSPACE ss WITH strategy_class = 'SimpleStrategy' AND
strategy_options:replication_factor = 1;
cqlsh> use ss;
cqlsh:ss> create columnfamily users (name text primary key, pass text);
cqlsh:ss> select * from users;
cqlsh:ss> insert into users (name, pass) values ('john', 'secret');
cqlsh:ss> select * from users;
name | pass |
john | secret |
cqlsh:ss> delete from users where name = 'john';
cqlsh:ss> select * from users;
name |
john |
cqlsh:ss>
==================================================
Should be:
==================================================
cqlsh:ss> delete from users where name = 'john';
cqlsh:ss> select * from users;
cqlsh:ss>
==================================================
Environment: (was: Ubuntu 11.04
$ uname
Linux ubuntu-vbox 3.0.0-14-generic #23-Ubuntu SMP Mon Nov 21 20:34:47 UTC 2011
i686 i686 i386 GNU/Linux
$ java -version
java version "1.7.0_02"
Java(TM) SE Runtime Environment (build 1.7.0_02-b13)
Java HotSpot(TM) Client VM (build 22.0-b10, mixed mode)
(Oracle JVM))
> Can't delete row with cqlsh via row key
> ---------------------------------------
>
> Key: CASSANDRA-3645
> URL: https://issues.apache.org/jira/browse/CASSANDRA-3645
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Affects Versions: 1.0.6
> Reporter: Oleksandr Shyshko
> Labels: cql, cqlsh, delete
>
> Edit: this is probably not a bug, but standard ghost/deletion behavior.
> Reproduce by:
> ==================================================
> cqlsh> CREATE KEYSPACE ss WITH strategy_class = 'SimpleStrategy' AND
> strategy_options:replication_factor = 1;
> cqlsh> use ss;
> cqlsh:ss> create columnfamily users (name text primary key, pass text);
> cqlsh:ss> select * from users;
> cqlsh:ss> insert into users (name, pass) values ('john', 'secret');
> cqlsh:ss> select * from users;
> name | pass |
> john | secret |
> cqlsh:ss> delete from users where name = 'john';
> cqlsh:ss> select * from users;
> name |
> john |
> cqlsh:ss>
> ==================================================
> Desired behavior:
> ==================================================
> cqlsh:ss> delete from users where name = 'john';
> cqlsh:ss> select * from users;
> cqlsh:ss>
> ==================================================
--
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
