[jira] [Created] (CASSANDRA-6853) Allow filtering on primary key expressions in 2i queries

[Jonathan Ellis (JIRA)]

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)