[
https://issues.apache.org/jira/browse/CASSANDRA-3791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13200007#comment-13200007
]
Eric Evans commented on CASSANDRA-3791:
---------------------------------------
bq. 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'.
Yeah, it's definitely not working that way here.
There is a scqeal test for this (https://github.com/acunu/scqeal). From the
top-level directory run:
{noformat}
CQL_VERSION=3.0.0 DEBUG=1 SET_CQL_VERSION=3.0.0
CASSANDRA_HOME=/path/to/cassandra \
./runtests -sv
scqeal.tests.test_select:TestSelect.compactcf_query_by_names_test
{noformat}
> 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
