[ 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)