cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cathy Daw (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CASSANDRA-2548) CQL: After running DELETE without specifying columns, the key is still returned in queries
Date Fri, 29 Apr 2011 23:41:03 GMT

     [ 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

Mime
View raw message