[ https://issues.apache.org/jira/browse/CASSANDRA-10958?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15103004#comment-15103004 ]
Taiyuan Zhang commented on CASSANDRA-10958: ------------------------------------------- Any update here? > Range query with filtering interacts badly with static columns > -------------------------------------------------------------- > > Key: CASSANDRA-10958 > URL: https://issues.apache.org/jira/browse/CASSANDRA-10958 > Project: Cassandra > Issue Type: Bug > Reporter: Taiyuan Zhang > Assignee: Taiyuan Zhang > Priority: Minor > Attachments: 10958.patch > > > I'm playing with Cassandra 3. I added a secondary index on a column of > integer, then I want to do a range query. First it threw an error: > {code} > InvalidRequest: code=2200 [Invalid query] message="No supported secondary > index found for the non primary key columns restrictions" > {code} > So I added 'Allow Filtering' > {code} > cqlsh:mykeyspace> SELECT * FROM test ; > id | id2 | age | extra > ----+-----+-----+------- > 1 | 1 | 1 | 1 > 2 | 2 | 2 | 2 > (2 rows) > cqlsh:mykeyspace > CREATE INDEX test_age on test (extra) ; > cqlsh:mykeyspace > select * FROM test WHERE extra < 2 ALLOW FILTERING ; > id | id2 | age | extra > ----+------+-----+------- > 1 | 1 | 1 | 1 > 2 | null | 2 | null > (2 rows) > {code} > My schema is: > {code} > CREATE TABLE mykeyspace.test ( > id int, > id2 int, > age int static, > extra int, > PRIMARY KEY (id, id2) > ) > {code} > I don't know if this is by design or not, but it really does look like a BUG > to me. -- This message was sent by Atlassian JIRA (v6.3.4#6332)