[jira] [Commented] (CASSANDRA-3791) Support query by names for compact CF

["Eric Evans (Commented) (JIRA)" <ji...@apache.org>]

    [ 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