Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of jbellis@gmail.com designates
 74.125.82.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <AD29CF26-4E4B-4AE6-A595-90ACB9A8314B@rhapsody.com>
References: <AD29CF26-4E4B-4AE6-A595-90ACB9A8314B@rhapsody.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Fri, 22 Jul 2011 17:55:43 -0500
Message-ID: 
 <CALdd-zjOZz+Hmw+fBUn24QbPiL6ZvvLSXjM03oMw30qp+kFPAw@mail.gmail.com>
Subject: Re: CQL COUNT Not Accurate?
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Yes, this is broken.  We'll fix this for
https://issues.apache.org/jira/browse/CASSANDRA-2474

On Fri, Jul 22, 2011 at 4:18 PM, Hefeng Yuan <hfyuan@rhapsody.com> wrote:
> Hi,
>
> I just noticed that the count(*) in CQL seems to be having wrong answer, when I have only one row, the count(*) returns two.
>
> Below are the commands I tried:
>
> cqlsh> SELECT COUNT(*) FROM UserProfile USING CONSISTENCY QUORUM WHERE KEY IN ('00D760DB1730482D81BC6845F875A97D');
> (2,)
> cqlsh> select * from UserProfile where key = '00D760DB1730482D81BC6845F875A97D';
> u'00D760DB1730482D81BC6845F875A97D' | u'ScreenName','3D5C78CAE2E143FBBD1F539A8496D472'
>
> Is this a known bug? Or I did something wrong?
>
> Thanks,
> Hefeng


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