[CASSANDRA-8397] Support UPDATE with IN requirement for clustering key

• Type: Improvement
• Status: Resolved
• Priority: Low
• Resolution: Duplicate
• Assignee: Benjamin Lerer
• Reporter: Jens Rantil

Authors

Benjamin Lerer

• Created: 01/Dec/14 12:10
• Updated: 16/Apr/19 09:31
• Resolved: 23/Mar/15 10:58

Description

CREATE TABLE events (
    userid uuid,
    id timeuuid,
    content text,
    type text,
    PRIMARY KEY (userid, id)
)

# Add data

cqlsh:mykeyspace> UPDATE events SET content='Hello' WHERE userid=57b47f85-56c4-4968-83cf-4c4e533944e9 AND id IN (046e9da0-7945-11e4-a76f-770773bbbf7e, 046e0160-7945-11e4-a76f-770773bbbf7e);
code=2200 [Invalid query] message="Invalid operator IN for PRIMARY KEY part id"

I was surprised this doesn't work.

Issue Links

• duplicates: CASSANDRA-6237 Allow range deletions in CQL