[ https://issues.apache.org/jira/browse/CASSANDRA-10264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14745662#comment-14745662 ]
Benjamin Lerer commented on CASSANDRA-10264: -------------------------------------------- In fact there is 2 problems: one in cqlsh which trigger the invalid syntax and one in {{ModificationStatement}} that prevent the query of being executed and return an error. Both are already there in 2.1. I have some patch running on CI. > Unable to use conditions on static columns for DELETE > ----------------------------------------------------- > > Key: CASSANDRA-10264 > URL: https://issues.apache.org/jira/browse/CASSANDRA-10264 > Project: Cassandra > Issue Type: Bug > Components: Core > Environment: Cassandra 2.2.0 > Reporter: DOAN DuyHai > Assignee: Benjamin Lerer > > {noformat} > 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; > ^ > {noformat} > Same error if using =, <, <=, >= or > condition > According to [~thobbs] the syntax should work. Plus, the error message is > wrong -- This message was sent by Atlassian JIRA (v6.3.4#6332)