[CASSANDRA-7355] WHERE (c1,c2) IN ((v1,v2),(v3,v4)) fails

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Duplicate
• Severity: Normal
• Assignee: Unassigned
• Reporter: Sergey Nagaytsev
• Created: 05/Jun/14 09:56
• Updated: 16/Apr/19 09:31
• Resolved: 05/Jun/14 16:58

Description

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.