Return-Path: X-Original-To: apmail-cassandra-commits-archive@www.apache.org Delivered-To: apmail-cassandra-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 05BD310964 for ; Mon, 13 Jan 2014 21:32:52 +0000 (UTC) Received: (qmail 92040 invoked by uid 500); 13 Jan 2014 21:13:41 -0000 Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org Received: (qmail 91889 invoked by uid 500); 13 Jan 2014 21:13:22 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 91690 invoked by uid 99); 13 Jan 2014 21:12:52 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 13 Jan 2014 21:12:52 +0000 Date: Mon, 13 Jan 2014 21:12:52 +0000 (UTC) From: "Jonathan Ellis (JIRA)" To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (CASSANDRA-6579) LIMIT 1 fails while doing a select with index field in where clause MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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)