[CASSANDRA-6873] Static columns with IF NOT EXISTS don't always work as expected

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.0.7
• Severity: Low
• Assignee: Sylvain Lebresne
• Reporter: Sylvain Lebresne

Authors

Sylvain Lebresne

Reviewers

Aleksey Yeschenko

• Created: 17/Mar/14 09:25
• Updated: 16/Apr/19 09:31
• Resolved: 19/Mar/14 09:59

Description

Given:

CREATE TABLE test (
    id int,
    k text,
    version int static,
    v int,
    PRIMARY KEY (id, k)
)

INSERT INTO test(id, k, v) VALUES (1, 'foo', 'foo')

the following conditional update should not apply:

INSERT INTO test(id, k, version) VALUES (1, 'foo', 1) IF NOT EXISTS

since said query involves the clustering column and the CQL row with said clustering column already exists. It does currently apply however.