[ https://issues.apache.org/jira/browse/CASSANDRA-3791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13199578#comment-13199578 ]
Sylvain Lebresne commented on CASSANDRA-3791: --------------------------------------------- Not sure I understand what you mean, it's supposed to return *all* matching results (if the code doesn't do that, it's a bug). Taking the example in the description, it should return 3 results, one for each value of 'c'. To add some precision, and in case that was what you meant, the intent here is to only support to do a IN on the last part of the PRIMARY KEY (and on the first part since it's already supported). CASSANDRA-2710 will allow to have a IN on other parts of the PK but that's future work. > Support query by names for compact CF > ------------------------------------- > > Key: CASSANDRA-3791 > URL: https://issues.apache.org/jira/browse/CASSANDRA-3791 > Project: Cassandra > Issue Type: Sub-task > Components: API > Reporter: Sylvain Lebresne > Assignee: Sylvain Lebresne > Priority: Minor > Labels: cql3 > Fix For: 1.1 > > Attachments: 0001-Refactor-select.patch, > 0002-Allow-IN-on-last-column-of-PRIMARY-KEY.patch > > > Current code don't allow doing a query by names on wide rows (compact CF). > I.e. with: > {noformat} > CREATE TABLE test1 ( > k int, > c int, > v int, > PRIMARY KEY (k, c) > ) WITH COMPACT STORAGE; > {noformat} > you cannot do: > {noformat} > SELECT v FROM test1 WHERE k = 0 AND c IN (5, 2, 8) > {noformat} > even though this is a simple name query. > This ticket proposes to allow it. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira