[CASSANDRA-10264] Unable to use conditions on static columns for DELETE

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 2.1.12, 2.2.4, 3.0.0
• Component/s: Legacy/CQL

Environment

Cassandra 2.2.0

• Severity: Normal
• Since Version: 2.1.x
• Assignee: Benjamin Lerer
• Reporter: DuyHai Doan

Authors

Benjamin Lerer

Reviewers

Sylvain Lebresne

• Created: 03/Sep/15 20:38
• Updated: 16/Apr/19 09:30
• Resolved: 20/Oct/15 12:15

Description

cqlsh:test> create table static_table(id int, stat int static, ord int, val text, primary key(id,ord));
cqlsh:test> insert into static_table (id,stat,ord,val) VALUES ( 1, 1, 1, '1');
cqlsh:test> delete from static_table where id=1 and ord=1 if stat != 1;
Invalid syntax at line 1, char 55
  delete from static_table where id=1 and ord=1 if stat != 1;
                                                        ^

Same error if using =, <, <=, >= or > condition
According to thobbs the syntax should work. Plus, the error message is wrong