[ https://issues.apache.org/jira/browse/CASSANDRA-6579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sylvain Lebresne resolved CASSANDRA-6579. ----------------------------------------- Resolution: Duplicate Fix Version/s: (was: 2.0.4) 2.0.5 Thanks for the report. Resolving as duplicate however since the patch from CASSANDRA-6555 fixes this issue too. I did pushed the repro code from the description as a dtest though, as more tests never hurt. > 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 > Assignee: Sylvain Lebresne > Fix For: 2.0.5 > > > 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)