incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hefeng Yuan <hfy...@rhapsody.com>
Subject CQL COUNT Not Accurate?
Date Fri, 22 Jul 2011 21:18:37 GMT
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
Mime
View raw message