[CASSANDRA-4797] range queries return incorrect results

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Severity: Normal
• Assignee: Unassigned
• Reporter: Brandon Williams
• Created: 11/Oct/12 22:55
• Updated: 16/Apr/19 09:32
• Resolved: 26/Oct/12 12:48

Description

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.

======================================================================
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]]