[
https://issues.apache.org/jira/browse/CASSANDRA-2548?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Cathy Daw resolved CASSANDRA-2548.
----------------------------------
Resolution: Not A Problem
http://wiki.apache.org/cassandra/FAQ#range_ghosts
> CQL: After running DELETE without specifying columns, the key is still
> returned in queries
> ------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-2548
> URL: https://issues.apache.org/jira/browse/CASSANDRA-2548
> Project: Cassandra
> Issue Type: Bug
> Affects Versions: 0.8 beta 1
> Reporter: Cathy Daw
> Priority: Minor
> Labels: cql
>
> I am not sure if this is expected because of how cassandra-cli works, but
> coming from SQL I would expect that if I delete a row it doesn't show up in a
> subsequent select statement.
> *Test Case*
> {code}
> cqlsh> DELETE FROM users where KEY = 'user2';
> cqlsh> select * from users where KEY='user2';
> u'user2'
> {code}
> *Cassandra CLI shows no rows returned*
> {code}
> [default@cqldb] get users['user2'];
> Returned 0 results.
> [default@cqldb] list users;
> RowKey: user2
> [default@cqldb] del users ['user2'];
> row removed.
> [default@cqldb] list users;
> RowKey: user2
> {code}
> *Test Setup*
> {code}
> CREATE COLUMNFAMILY users (
> KEY varchar PRIMARY KEY,
> password varchar,
> gender varchar,
> session_token varchar,
> state varchar,
> birth_year bigint);
> INSERT INTO users (KEY, password, gender, state, birth_year) VALUES ('user2',
> 'ch@ngem3', 'f', 'CA', '1972');
> {code}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
