cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tyler Hobbs (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (CASSANDRA-7355) WHERE (c1,c2) IN ((v1,v2),(v3,v4)) fails
Date Thu, 05 Jun 2014 17:00:04 GMT

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

Tyler Hobbs resolved CASSANDRA-7355.
------------------------------------

    Resolution: Duplicate

This is a duplicate of CASSANDRA-6875, which will be in 2.0.9.

That will allow you to run the query like this:

{noformat}
SELECT * FROM some_acl
    WHERE entity=34ea33b0-ebc7-11e3-ac10-0800200c9a66
    AND (entity_sub, res, role, right) IN ((65a72940-ebc7-11e3-ac10-0800200c9a66, 1, 1, 1),
(65a72940-ebc7-11e3-ac10-0800200c9a66, 1, 1, 2))
{noformat}

In particular, you have to spit the partition key out from the clustering columns.

> WHERE (c1,c2) IN ((v1,v2),(v3,v4)) fails
> ----------------------------------------
>
>                 Key: CASSANDRA-7355
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-7355
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Sergey Nagaytsev
>
> Query:
> SELECT * FROM some_acl WHERE (entity, entity_sub, res, role, right) IN ((34ea33b0-ebc7-11e3-ac10-0800200c9a66,
65a72940-ebc7-11e3-ac10-0800200c9a66, 1, 1, 1), (34ea33b0-ebc7-11e3-ac10-0800200c9a66, 65a72940-ebc7-11e3-ac10-0800200c9a66,
1, 1, 2))
> Table:
> CREATE COLUMNFAMILY some_acl (
>     entity uuid,
>     entity_sub uuid,
>     res int,
>     role int,
>     right int,
>     ok boolean,
>     PRIMARY KEY ( entity,entity_sub,res,role,right )
> );
> Error:
> CQLSTATE[HY000] [2] line 1:164 missing EOF at ','
> (position of comma between two value groups)
> P.S. Maybe this can be replaced by huge WHERE (( c1=v1 AND c2=v2) OR (..)) AND ( other=condition
) in user's framework/DBAL, and is the parsing problem, not data access one.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message