cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CASSANDRA-6853) Allow filtering on primary key expressions in 2i queries
Date Thu, 13 Mar 2014 14:27:45 GMT
Jonathan Ellis created CASSANDRA-6853:
-----------------------------------------

             Summary: Allow filtering on primary key expressions in 2i queries
                 Key: CASSANDRA-6853
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6853
             Project: Cassandra
          Issue Type: New Feature
            Reporter: Jonathan Ellis
            Assignee: Sylvain Lebresne
            Priority: Minor
             Fix For: 3.0


We allow

{code}
SELECT a, d FROM t.t WHERE b = 'b1' AND a = 'a14521'
{code}

and

{code}
SELECT a, d FROM t.t WHERE b = 'b1' AND token(a)  > token( 'a14521')
{code}

but not
{code}
SELECT a, d FROM t.t WHERE b = 'b1' AND a  > 'a14521'
{code}

(given an index on {{b}}, with primary key {{a}})

we allow combining other predicates with an indexed one and filtering those in a nested loop;
we should allow the same for primary keys



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message