cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Benjamin Lerer (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CASSANDRA-10264) Unable to use conditions on static columns for DELETE
Date Thu, 17 Sep 2015 15:30:04 GMT

     [ https://issues.apache.org/jira/browse/CASSANDRA-10264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Benjamin Lerer updated CASSANDRA-10264:
---------------------------------------
    Attachment: 10264-3.0.txt
                10264-2.1.txt

The patches fix the problems describe earlier.

* the unit test results for 2.1 are [here|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-10264-2.1-testall/2/]
* the dtest results for 2.1 are [here|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-10264-2.1-dtest/3/]
* the unit test results for 2.2 are [here|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-10264-2.2-testall/2/]
* the dtest results for 2.2 are [here|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-10264-2.2-dtest/2/]
* the unit test results for 3.0 are [here|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-10264-3.0-testall/5/]
* the dtest results for 3.0 are [here|http://cassci.datastax.com/view/Dev/view/blerer/job/blerer-10264-3.0-dtest/4/]



> 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)

Mime
View raw message