Sergey Nagaytsev created CASSANDRA-7355:
-------------------------------------------
Summary: 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)
