[CASSANDRA-7804] Confusing error message when condition is set on primary key column

• Type: Bug
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 2.1.1
• Component/s: Feature/Lightweight Transactions
• Labels: LWT
• Severity: Low
• Assignee: Tom Hobbs
• Reporter: Tom Hobbs

Authors

Tom Hobbs

Reviewers

Sylvain Lebresne

• Created: 20/Aug/14 17:49
• Updated: 25/Oct/19 13:10
• Resolved: 28/Aug/14 15:50

Description

If you set a CAS condition on a primary key column, you'll get an error that's somewhat confusing:

cqlsh:ks1> CREATE TABLE mytable (a int PRIMARY KEY, b int);
cqlsh:ks1> UPDATE mytable SET b = 0 WHERE a = 0 IF a = 0;
code=2200 [Invalid query] message="PRIMARY KEY part a found in SET part"