[
https://issues.apache.org/jira/browse/CASSANDRA-10264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14954852#comment-14954852
]
Benjamin Lerer commented on CASSANDRA-10264:
--------------------------------------------
The updated patch for {{2.1}} is
[here|https://github.com/apache/cassandra/compare/cassandra-2.1...blerer:10264-2.1]
and the one for {{3.0}} is
[here|https://github.com/apache/cassandra/compare/trunk...blerer:10264-3.0].
Both patches make the code more explicit and fix the regular expression.
{{IF x = 3}} was previously working even if the regular expression was wrong.
It might be caused by some issue in the {{cqlsh}} grammar (CASSANDRA-10415).
Test results:
* the unit test results for 2.1 are
[here|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-10264-2.1-testall/3/]
* the dtest results for 2.1 are
[here|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-10264-2.1-dtest/4/]
* the unit test results for 2.2 are
[here|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-10264-2.2-testall/3/]
* the dtest results for 2.2 are
[here|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-10264-2.2-dtest/3/]
* the unit test results for 3.0 are
[here|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-10264-3.0-testall/6/]
* the dtest results for 3.0 are
[here|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-10264-3.0-dtest/5/]
> 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
> Attachments: 10264-2.1.txt, 10264-3.0.txt
>
>
> {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)
