[jira] [Resolved] (CASSANDRA-4831) CQL DELETE can not be used without where clause

["Jonathan Ellis (JIRA)" <ji...@apache.org>]

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

Jonathan Ellis resolved CASSANDRA-4831.
---------------------------------------

    Resolution: Not A Problem

Thanks for looking into that.  CQL2 is maintenance-mode only so we'll note that as a known problem there.
                
> 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