[jira] [Updated] (CASSANDRA-3349) NPE on malformed CQL

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

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

Jonathan Ellis updated CASSANDRA-3349:
--------------------------------------

    Fix Version/s: 1.0.1
                   0.8.8
         Assignee: Pavel Yaskevich

We don't want to allow leaving it off, because we don't support scan-and-delete server-side. (And truncate is far more performant.)

I'd rather fix by requiring the rest of the WHERE.
                
> NPE on malformed CQL
> --------------------
>
>                 Key: CASSANDRA-3349
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-3349
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>    Affects Versions: 0.8.0 beta 2
>            Reporter: paul cannon
>            Assignee: Pavel Yaskevich
>              Labels: lhf
>             Fix For: 0.8.8, 1.0.1
>
>
> It's not clear why, but the CQL grammar specification in Cql.g allows for an empty WHERE clause on DELETE, i.e.:
> {noformat}
> DELETE FROM someCF WHERE;
> {noformat}
> When this is used, with or without a column list, it causes an NPE on the node processing the CQL. Traceback on a recent 1.0.0 build:
> {noformat}
> ERROR [pool-2-thread-1] 2011-10-11 15:45:25,655 Cassandra.java (line 4082) Internal error processing execute_cql_query
> java.lang.NullPointerException
>         at org.apache.cassandra.cql.CqlParser.deleteStatement(CqlParser.java:1994)
>         at org.apache.cassandra.cql.CqlParser.query(CqlParser.java:292)
>         at org.apache.cassandra.cql.QueryProcessor.getStatement(QueryProcessor.java:984)
>         at org.apache.cassandra.cql.QueryProcessor.process(QueryProcessor.java:500)
>         at org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1268)
>         at org.apache.cassandra.thrift.Cassandra$Processor$execute_cql_query.process(Cassandra.java:4072)
>         at org.apache.cassandra.thrift.Cassandra$Processor.process(Cassandra.java:2889)
>         at org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:187)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>         at java.lang.Thread.run(Thread.java:680)
> {noformat}
> The CQL client gets an error with the message, "Internal application error".
> It might be better to allow leaving off the "WHERE" as well as the condition, to match SQL semantics, although fixing that probably won't solve this problem.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira