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

2018-11-18 Thread C. Scott Andreas (JIRA) 


 [ 
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-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

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

2014-03-13 Thread Jonathan Ellis (JIRA) 

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

Jonathan Ellis updated CASSANDRA-6853:
--

Labels: indexes  (was: )

 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
  Labels: indexes
 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)