From users-return-15166-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org Tue Apr 27 08:14:11 2010 Return-Path: Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: (qmail 55979 invoked from network); 27 Apr 2010 08:14:11 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 27 Apr 2010 08:14:11 -0000 Received: (qmail 84187 invoked by uid 500); 27 Apr 2010 08:14:10 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 84076 invoked by uid 500); 27 Apr 2010 08:14:10 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 84066 invoked by uid 99); 27 Apr 2010 08:14:09 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Apr 2010 08:14:09 +0000 X-ASF-Spam-Status: No, hits=1.7 required=10.0 tests=AWL,FREEMAIL_FROM,SPF_HELO_PASS,SPF_NEUTRAL,T_TO_NO_BRKTS_FREEMAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: 216.139.236.158 is neither permitted nor denied by domain of gadbury@googlemail.com) Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Apr 2010 08:14:03 +0000 Received: from joe.nabble.com ([192.168.236.151]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1O6fvL-0002Hl-5e for users@jackrabbit.apache.org; Tue, 27 Apr 2010 01:13:43 -0700 Date: Tue, 27 Apr 2010 01:13:43 -0700 (PDT) From: Gadbury To: users@jackrabbit.apache.org Message-ID: <1272356023168-2067212.post@n4.nabble.com> In-Reply-To: References: <1271232828988-1839436.post@n4.nabble.com> <1271235488423-1839484.post@n4.nabble.com> <1271241648976-1839593.post@n4.nabble.com> <1272287695733-2065160.post@n4.nabble.com> Subject: Re: NodeIterator.getSize() returns -1 for query with order by clause MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Alex, Supplying an order by constraint does not always solve the problem of node/rowIterator.getSize() returning -1. select * from [my:order] as orders where orders.[orderStatus] = 2 order by orders.[jcr:created] asc The above query returns the correct amount of nodes BUT nodeIterator.getSize() returns -1. select * from [my:order] as orders order by orders.[jcr:created] asc The above query returns the correct amount of nodes AND nodeIterator.getSize() returns the correct value. So there are cases when supplying order by DOES NOT force a count. Sorry if I am misunderstanding you. -- View this message in context: http://jackrabbit.510166.n4.nabble.com/NodeIterator-getSize-returns-1-for-query-with-order-by-clause-tp1839436p2067212.html Sent from the Jackrabbit - Users mailing list archive at Nabble.com.