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