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
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
