Sridharan Kuppa created CASSANDRA-4831:
------------------------------------------
Summary: 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
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
