cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Oleksandr Shyshko (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-3645) Can't delete row with cqlsh via row key
Date Sun, 18 Dec 2011 14:22:30 GMT

     [ 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

        

Mime
View raw message