[
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