cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tyler Hobbs (JIRA)" <>
Subject [jira] [Commented] (CASSANDRA-6950) Secondary index query fails with tc range query when ordered by DESC
Date Tue, 20 May 2014 18:32:38 GMT


Tyler Hobbs commented on CASSANDRA-6950:

The Thrift behavior is such an uncommon case that I'm not concerned about fixing it, I just
thought it shouldn't get in the way of making our preferred fix.  If you prefer the current
patch over changing {{ExtendedFilter.isSatisfiedBy()}}, then I'm +1 on the patch.

> Secondary index query fails with tc range query when ordered by DESC
> --------------------------------------------------------------------
>                 Key: CASSANDRA-6950
>                 URL:
>             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
>            Reporter: Andre Campeau
>            Assignee: Sylvain Lebresne
>             Fix For: 2.0.8
>         Attachments:, 6950.txt
>     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

View raw message