[
https://issues.apache.org/jira/browse/CASSANDRA-6853?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17715773#comment-17715773
]
Michael Semb Wever commented on CASSANDRA-6853:
-----------------------------------------------
[~mike_tr_adamson], does CASSANDRA-16052 address this?
> 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: Feature/2i Index
> Reporter: Jonathan Ellis
> Assignee: Sylvain Lebresne
> Priority: Low
> Labels: indexes
> Fix For: 5.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
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
