You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Tyler Hobbs (JIRA)" <ji...@apache.org> on 2014/06/05 19:00:04 UTC
[jira] [Resolved] (CASSANDRA-7355) WHERE (c1,c2) IN
((v1,v2),(v3,v4)) fails
[ 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)