Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Mon, 14 Sep 2015 23:08:45 +0000 (UTC)
From: "Jim Witschey (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12861671.1441312728000.336347.1442272125924@Atlassian.JIRA>
In-Reply-To: <JIRA.12861671.1441312728000@Atlassian.JIRA>
References: <JIRA.12861671.1441312728000@Atlassian.JIRA>
 <JIRA.12861671.1441312728570@arcas>
Subject: [jira] [Commented] (CASSANDRA-10264) Unable to use conditions on
 static columns for DELETE
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/CASSANDRA-10264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14744466#comment-14744466 ] 

Jim Witschey commented on CASSANDRA-10264:
------------------------------------------

Calling this via the Python driver on Cassandra 2.1 and up results in the error message {{Invalid restriction on clustering column ord since the DELETE statement modifies only static columns}}. I'll need a developer to have a look to see if this behavior is correct.

I have reproduced this through cqlsh, though, so I think this is either an issue in the bundled driver or in cqlsh. [~Stefania] can you take this or recommend someone I can assign this to? I've reproduced this on a scratch branch:

https://github.com/mambocab/cassandra-dtest/tree/CASSANDRA-10264

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