[ https://issues.apache.org/jira/browse/CASSANDRA-4797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13484883#comment-13484883 ]
julien campan edited comment on CASSANDRA-4797 at 10/26/12 12:48 PM: --------------------------------------------------------------------- Hi, I have the same problem when using cassandra 1.2 beta 1 with vnode : I 'm using cql 3. My table has 66 000 rows : {noformat} cqlsh:pns_fr> select count(*) from syndic limit 100 ; count ------- 100 cqlsh:pns_fr> select count(*) from syndic limit 1000 ; count ------- 999 cqlsh:pns_fr> select count(*) from syndic limit 10000 ; count 9983 cqlsh:pns_fr> select count(*) from syndic limit 100000 ; count ------- 65883 {noformat} was (Author: julien_campan): Hi, I have the same problem when using cassandra 1.2 beta 1 with vnode : I 'm using cql 3. My table has 66 000 rows : cqlsh:pns_fr> select count(*) from syndic limit 100 ; count ------- 100 cqlsh:pns_fr> select count(*) from syndic limit 1000 ; count ------- 999 cqlsh:pns_fr> select count(*) from syndic limit 10000 ; count 9983 cqlsh:pns_fr> select count(*) from syndic limit 100000 ; count ------- 65883 > range queries return incorrect results > -------------------------------------- > > Key: CASSANDRA-4797 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4797 > Project: Cassandra > Issue Type: Bug > Components: Core > Reporter: Brandon Williams > Fix For: 1.2.0 > > > I've only seen this fail once, but it's quite obviously returning incorrect > results since the query is "SELECT * FROM clicks WHERE userid >= 2 LIMIT 1" > and it's getting userid 0 in return. > {noformat} > ====================================================================== > FAIL: cql_tests.TestCQL.limit_ranges_test > Validate LIMIT option for 'range queries' in SELECT statements > ---------------------------------------------------------------------- > Traceback (most recent call last): > File "/usr/lib/pymodules/python2.7/nose/case.py", line 183, in runTest > self.test(*self.arg) > File "/var/lib/buildbot/cassandra-dtest/tools.py", line 187, in wrapped > f(obj) > File "/var/lib/buildbot/cassandra-dtest/cql_tests.py", line 302, in > limit_ranges_test > assert res == [[ 2, 'http://foo.com', 42 ]], res > AssertionError: [[0, u'http://foo.com', 42]] > {noformat} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira