cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4831) CQL DELETE can not be used without where clause
Date Thu, 18 Oct 2012 20:14:03 GMT

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

Jonathan Ellis commented on CASSANDRA-4831:
-------------------------------------------

Do you get the same error with cql3?
                
> CQL DELETE can not be used without where clause
> -----------------------------------------------
>
>                 Key: CASSANDRA-4831
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4831
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 1.1.5
>         Environment: CQLSH
>            Reporter: Sridharan Kuppa
>              Labels: cql, delete, nullpointer
>
>  I have created table schema using CQL, and I am able to insert and select from that
table.  Everything works great but DELETE is not working.  When I execute the DELETE statement
it throws "Bad Request: Failed parsing statement: [COL1, COL2, from TABLE1;] reason NullPointerException:
null"  I tried without column names and with column names but always throws the same exception.
But it works only if where is clause is specified.  The problem can be easily visualize using
the cqlsh.
> Connected to Test Cluster at localhost:9160.
> [cqlsh 2.2.0 | Cassandra 1.1.5 | CQL spec 2.0.0 | Thrift protocol 19.32.0]
> Use HELP for help.
> cqlsh>
> cqlsh> use demo1;
> cqlsh:demo1> create table user (id varchar primary key, fname varchar, lname varchar);
> cqlsh:demo1> insert into user (id, fname, lname) values (1, 'john', 'doe');
> cqlsh:demo1> insert into user (id, fname, lname) values (2, 'foo', 'bar');
> cqlsh:demo1> delete from user;
> Bad Request: Failed parsing statement: [delete from user;] reason: NullPointerException
null
> cqlsh:demo1> delete fname, lname from user;
> Bad Request: Failed parsing statement: [delete fname, lname from user;] reason: NullPointerException
null
> cqlsh:demo1> delete from user where id = 2;
> cqlsh:demo1>

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message