Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Fri, 26 Oct 2012 12:49:13 +0000 (UTC)
From: "julien campan (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <835249163.31831.1351255753454.JavaMail.jiratomcat@arcas>
In-Reply-To: <1055885982.33528.1349996223177.JavaMail.jiratomcat@arcas>
Subject: [jira] [Comment Edited] (CASSANDRA-4797) range queries return
 incorrect results
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ 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