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 <hfy...@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