[
https://issues.apache.org/jira/browse/CASSANDRA-3645?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Oleksandr Shyshko updated CASSANDRA-3645:
-----------------------------------------
Description:
This is probably not a bug, but standard tombstone/deletion behavior.
Probably it would be nice to have a built-in filter for tombstones, so they
won't appears in queries.
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:
Edit: this is probably not a bug, but standard tombstone/deletion behavior.
Probably it would be nice to have a built-in filter for tombstones, so they
won't appears in queries.
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>
==================================================
> 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
>
> This is probably not a bug, but standard tombstone/deletion behavior.
> Probably it would be nice to have a built-in filter for tombstones, so they
> won't appears in queries.
> 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
