You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "DOAN DuyHai (JIRA)" <ji...@apache.org> on 2015/09/03 22:39:45 UTC
[jira] [Updated] (CASSANDRA-10264) Unable to use conditions on
static columns for DELETE
[ https://issues.apache.org/jira/browse/CASSANDRA-10264?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
DOAN DuyHai updated CASSANDRA-10264:
------------------------------------
Description:
{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
was:
{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
> 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)