[
https://issues.apache.org/jira/browse/CASSANDRA-4797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13484883#comment-13484883
]
julien campan commented on CASSANDRA-4797:
------------------------------------------
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
