[
https://issues.apache.org/jira/browse/CASSANDRA-4797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13486769#comment-13486769
]
julien campan commented on CASSANDRA-4797:
------------------------------------------
Hi, i took the trunk version this morning and i still have the problem.
I'm using : [cqlsh 2.3.0 | Cassandra 1.2.0-beta1-SNAPSHOT | CQL spec 3.0.0 |
Thrift protocol 19.35.0]
My use case is :
I create a table
CREATE TABLE premier (
id int PRIMARY KEY,
value int
) WITH
comment='' AND
caching='KEYS_ONLY' AND
read_repair_chance=0.100000 AND
dclocal_read_repair_chance=0.000000 AND
gc_grace_seconds=864000 AND
replicate_on_write='true' AND
compression={'sstable_compression': 'SnappyCompressor'};
1) I insert 10 000 000 rows (they are like id = 1 and value =1)
2) I delete 2 000 000 rows (i use random method to choose the key value)
3) I do select * from premier ; and my result is 7944 instead of 10 000.
So after a lot of delete, the range operator is not working.
> 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
