[jira] [Reopened] (CASSANDRA-6318) IN predicates on non-primary-key columns (%s) is not yet supported

["Sergey Nagaytsev (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-6318?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sergey Nagaytsev reopened CASSANDRA-6318:
-----------------------------------------

    Reproduced In: 2.0.3, 2.0.2  (was: 2.0.2)

Still reproduces in 2.0.3, test .cql file attached.

> IN predicates on non-primary-key columns (%s) is not yet supported
> ------------------------------------------------------------------
>
>                 Key: CASSANDRA-6318
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6318
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Sergey Nagaytsev
>              Labels: cql3
>         Attachments: CASSANDRA_6318_test.cql
>
>
> Query:
> SELECT * FROM post WHERE blog IN (1,2) AND author=3 ALLOW FILTERING -- contrived
> Error: IN predicates on non-primary-key columns (blog) is not yet supported
> Please either implement, set milestone or say will never be implemented !
> P.S. Did search, seemingly found no issue/plan related to it. Maybe CASSANDRA-6048 ?
> P.S.2 What is recommended workaround for this ? Manual index tables, what are design guidelines for them ?



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)