[ 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)