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

["C. Scott Andreas (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-6853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

C. Scott Andreas updated CASSANDRA-6853:
----------------------------------------
    Component/s: Secondary Indexes

> 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
>          Components: Secondary Indexes
>            Reporter: Jonathan Ellis
>            Assignee: Sylvain Lebresne
>            Priority: Minor
>              Labels: indexes
>             Fix For: 4.x
>
>
> 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
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org