cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sylvain Lebresne (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-6173) Unable to delete multiple entries using In clause on clustering part of compound key
Date Thu, 10 Oct 2013 07:00:47 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-6173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sylvain Lebresne updated CASSANDRA-6173:
----------------------------------------

    Issue Type: New Feature  (was: Bug)

> Unable to delete multiple entries using In clause on clustering part of compound key
> ------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-6173
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6173
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: Core
>            Reporter: Ashot Golovenko
>            Priority: Minor
>
> I have the following table:
> CREATE TABLE user_relation (
>     u1 bigint,
>     u2 bigint,
>     mf int,
>     i boolean,
>     PRIMARY KEY (u1, u2));
> And I'm trying to delete two entries using In clause on clustering part of compound key
and I fail to do so:
> cqlsh:bm> DELETE from user_relation WHERE u1 = 755349113 and u2 in (100003404014120,
100002537242743);
> Bad Request: Invalid operator IN for PRIMARY KEY part u2
> Although the select statement works just fine:
> cqlsh:bm> select * from user_relation WHERE u1 = 755349113 and u2 in (100003404014120,
100002537242743);
>  u1        | u2              | i    | mf
> -----------+-----------------+------+----
>  755349113 | 100002537242743 | null | 27
>  755349113 | 100003404014120 | null |  0
> (2 rows)



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message