[jira] [Created] (CASSANDRA-6579) LIMIT 1 fails while doing a select with index field in where clause

[David Morales (JIRA)]

David Morales created CASSANDRA-6579:
----------------------------------------

             Summary: LIMIT 1 fails while doing a select with index field in 
where clause
                 Key: CASSANDRA-6579
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6579
             Project: Cassandra
          Issue Type: Bug
          Components: API
         Environment: UBUNTU 12.04, single node
            Reporter: David Morales
            Priority: Critical
             Fix For: 2.0.4


create table test(field1 text, field2 timeuuid, field3 boolean, primary 
key(field1, field2));
create index test_index on test(field3);
insert into test(field1, field2, field3) values ('hola', now(), false);
insert into test(field1, field2, field3) values ('hola', now(), false);


Now doing a select:

select count(*) from test where field3 = false limit 1;


will result in this excepcion


java.lang.IllegalArgumentException: fromIndex(0) > toIndex(-1)
    at java.util.ArrayList.subListRangeCheck(ArrayList.java:924)
    at java.util.ArrayList.subList(ArrayList.java:914)
    at 
org.apache.cassandra.service.pager.AbstractQueryPager.discardLast(AbstractQueryPager.java:243)
    at 
org.apache.cassandra.service.pager.AbstractQueryPager.fetchPage(AbstractQueryPager.java:86)
    at 
org.apache.cassandra.service.pager.RangeSliceQueryPager.fetchPage(RangeSliceQueryPager.java:36)
    at 
org.apache.cassandra.cql3.statements.SelectStatement.pageCountQuery(SelectStatement.java:202)
    at 
org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:169)
    at 
org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:58)
    at 
org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:188)
    at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:222)
    at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:212)
    at 
org.apache.cassandra.thrift.CassandraServer.execute_cql3_query(CassandraServer.java:1958)
    at 
org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4486)
    at 
org.apache.cassandra.thrift.Cassandra$Processor$execute_cql3_query.getResult(Cassandra.java:4470)
    at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
    at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
    at 
org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:194)
    at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:724)



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)