[jira] [Created] (CASSANDRA-10264) Unable to use conditions on static columns for DELETE

["DOAN DuyHai (JIRA)" <ji...@apache.org>]

DOAN DuyHai created CASSANDRA-10264:
---------------------------------------

             Summary: 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


{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}

According to [~thobbs] the syntax should work. Plus, the error message is wrong



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)