Andre Campeau created CASSANDRA-6950:
----------------------------------------
Summary: Secondary index query fails with tc range query when
ordered by DESC
Key: CASSANDRA-6950
URL: https://issues.apache.org/jira/browse/CASSANDRA-6950
Project: Cassandra
Issue Type: Bug
Components: Core
Environment: RHEL 6.3 virtual guest,
apache-cassandra-2.0.6-SNAPSHOT-src.tar.gz from build #284 (also tried with
2.0.5 with CASSANDRA-6666 patch custom-applied with same result).
Reporter: Andre Campeau
create table test4 ( name text, lname text, tc bigint, record text, PRIMARY
KEY ((name, lname), tc)) WITH CLUSTERING ORDER BY (tc DESC) AND
compaction={'class': 'LeveledCompactionStrategy'};
create index test4_index ON test4(lname);
Populate it with some data and non-zero tc values, then try:
select * from test4 where lname='blah' and tc>0 allow filtering;
And, (0 rows) returned, even though there are rows which should be found.
When I create the table using CLUSTERING ORDER BY (tc ASC), the above query
works. Rows are correctly returned based on the range check.
Tried various combinations but with descending order on tc nothing works.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
