You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cassandra.apache.org by Hefeng Yuan <hf...@rhapsody.com> on 2011/08/23 01:58:44 UTC

CQL count(*) counts deleted records?

We're using 0.8.1, and found the CQL count(*) is counting deleted columns, CLI doesn't have this issue. Is it a bug?

cqlsh> select * from CF where key = 'foo';
u'foo'

cqlsh> select count(*) from CF where key = 'foo';
(3,)

Re: CQL count(*) counts deleted records?

Posted by Jonathan Ellis <jb...@gmail.com>.

Yes.

On Mon, Aug 22, 2011 at 6:58 PM, Hefeng Yuan <hf...@rhapsody.com> wrote:
> We're using 0.8.1, and found the CQL count(*) is counting deleted columns, CLI doesn't have this issue. Is it a bug?
>
> cqlsh> select * from CF where key = 'foo';
> u'foo'
>
> cqlsh> select count(*) from CF where key = 'foo';
> (3,)



-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com