cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andre Campeau (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-6950) Secondary index query fails with tc range query when ordered by DESC
Date Fri, 28 Mar 2014 17:43:20 GMT
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)

Mime
View raw message