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

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

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

Jonathan Ellis updated CASSANDRA-6579:
--------------------------------------

    Priority: Major  (was: Critical)
    Assignee: Sylvain Lebresne

> 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.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)