[CASSANDRA-10532] Allow LWT operation on static column with only partition keys

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.1.15, 2.2.7, 3.0.8, 3.8
• Component/s: Feature/Lightweight Transactions, Legacy/CQL
• Labels: LWT

Environment

C* 2.2.0

• Assignee: Carl Yeksigian
• Reporter: DuyHai Doan

Authors

Carl Yeksigian

Reviewers

Benjamin Lerer

• Created: 15/Oct/15 12:18
• Updated: 25/Oct/19 13:10
• Resolved: 14/Jun/16 14:37

Description

Schema

CREATE TABLE IF NOT EXISTS achilles_embedded.entity_with_static_column(
id bigint,
uuid uuid,
static_col text static,
value text,
PRIMARY KEY(id, uuid));

When trying to prepare the following query

DELETE static_col FROM achilles_embedded.entity_with_static_column WHERE id=:id_Eq IF static_col=:static_col;

I got the error DELETE statements must restrict all PRIMARY KEY columns with equality relations in order to use IF conditions, but column 'uuid' is not restricted

Since the mutation only impacts the static column and the CAS check is on the static column, it makes sense to provide only partition key

Issue Links

• is depended upon by: CASSANDRA-9842 Inconsistent behavior for '= null' conditions on static columns
• is depended upon by: CASSANDRA-11843 Improve test coverage for conditional deletes