[ https://issues.apache.org/jira/browse/CASSANDRA-2538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13023469#comment-13023469 ]
Jonathan Ellis commented on CASSANDRA-2538: ------------------------------------------- Totally didn't know we support IN for DELETE. :) Would prefer to fix by offering IN for for the other statements as well. The Antlr doesn't look too daunting w/ DELETE as an example (knock on wood). Can take a stab at that tomorrow. > CQL: NPE running SELECT with an IN clause > ----------------------------------------- > > Key: CASSANDRA-2538 > URL: https://issues.apache.org/jira/browse/CASSANDRA-2538 > Project: Cassandra > Issue Type: Bug > Affects Versions: 0.8 beta 1 > Reporter: Cathy Daw > Assignee: Eric Evans > Priority: Minor > Labels: cql > Fix For: 0.8.0 > > Attachments: > v1-0001-CASSANDRA-2538-NPE-running-SELECT-with-an-IN-clause.txt > > > *Test Case to Run* > {noformat} > cqlsh> select * from users where key in ('user2', 'user3'); > Internal application error > {noformat} > *Test Setup* > {noformat} > CREATE COLUMNFAMILY users ( > KEY varchar PRIMARY KEY, > password varchar); > INSERT INTO users (KEY, password) VALUES ('user1', 'ch@ngem3a'); > {noformat} > *Log Files* > {noformat} > ERROR [RequestResponseStage:17] 2011-04-21 23:36:41,600 > AbstractCassandraDaemon.java (line 112) Fatal exception in thread > Thread[RequestResponseStage:17,5,main] > java.lang.AssertionError > at > org.apache.cassandra.service.ReadCallback.response(ReadCallback.java:127) > at > org.apache.cassandra.net.ResponseVerbHandler.doVerb(ResponseVerbHandler.java:49) > at > org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:72) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > at java.lang.Thread.run(Thread.java:636) > ERROR [RequestResponseStage:17] 2011-04-21 23:36:41,600 > AbstractCassandraDaemon.java (line 112) Fatal exception in thread > Thread[RequestResponseStage:17,5,main] > java.lang.AssertionError > at > org.apache.cassandra.service.ReadCallback.response(ReadCallback.java:127) > at > org.apache.cassandra.net.ResponseVerbHandler.doVerb(ResponseVerbHandler.java:49) > at > org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:72) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > at java.lang.Thread.run(Thread.java:636) > ERROR [pool-2-thread-5] 2011-04-21 23:37:12,026 Cassandra.java (line 4082) > Internal error processing execute_cql_query > java.lang.NullPointerException > at org.apache.cassandra.cql.WhereClause.and(WhereClause.java:59) > at org.apache.cassandra.cql.WhereClause.<init>(WhereClause.java:44) > at org.apache.cassandra.cql.CqlParser.whereClause(CqlParser.java:816) > at > org.apache.cassandra.cql.CqlParser.selectStatement(CqlParser.java:502) > at org.apache.cassandra.cql.CqlParser.query(CqlParser.java:191) > at > org.apache.cassandra.cql.QueryProcessor.getStatement(QueryProcessor.java:834) > at > org.apache.cassandra.cql.QueryProcessor.process(QueryProcessor.java:463) > at > org.apache.cassandra.thrift.CassandraServer.execute_cql_query(CassandraServer.java:1134) > 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.runWorker(ThreadPoolExecutor.java:1110) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) > at java.lang.Thread.run(Thread.java:636) > {noformat} -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira