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

["Sergey Nagaytsev (JIRA)" <ji...@apache.org>]

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)