[CASSANDRA-6950] Secondary index query fails with tc range query when ordered by DESC

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.0.8
• Component/s: Feature/2i Index

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).

• Severity: Normal
• Assignee: Sylvain Lebresne
• Reporter: Andre Campeau

Authors

Sylvain Lebresne

Reviewers

Tom Hobbs

• Created: 28/Mar/14 17:42
• Updated: 16/Apr/19 09:31
• Resolved: 21/May/14 09:39

Description

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.