[ https://issues.apache.org/jira/browse/CASSANDRA-3791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13199264#comment-13199264 ]
Eric Evans commented on CASSANDRA-3791: --------------------------------------- Since this only returns one matching result (the last), it seems like it's bound to confuse a lot of people; Are we sure this is the best idea? > 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