Return-Path: Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: (qmail 79685 invoked from network); 14 Apr 2010 09:13:25 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 14 Apr 2010 09:13:25 -0000 Received: (qmail 15342 invoked by uid 500); 14 Apr 2010 09:13:24 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 15262 invoked by uid 500); 14 Apr 2010 09:13:24 -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 15248 invoked by uid 99); 14 Apr 2010 09:13:24 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Apr 2010 09:13:24 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of 1111software@gmail.com designates 209.85.211.191 as permitted sender) Received: from [209.85.211.191] (HELO mail-yw0-f191.google.com) (209.85.211.191) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 14 Apr 2010 09:13:18 +0000 Received: by ywh29 with SMTP id 29so10034893ywh.14 for ; Wed, 14 Apr 2010 02:12:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:received:message-id:subject:from:to:content-type; bh=K3lPxAyiAIG9+qBrAz+ar7UumlmtM8qxrQct3V6F5YI=; b=pmAaGew2WojL921JDj0JVvD8gSfFwfyyw9AAsGX3AexBF9QPQvdgGv59TMKm9Fwksu vvexvj+rwQuwcp+UnLkeyCLppY2RfDBsCntyB5hBWYAoqw615+0oNiaYel/UnWs9/dLC uNByvC5EQiwaEXB224BPgEq5ku4/tRwy6NVCo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=lRwftgh0ojUvaWXDi146wuyLTKxi4tvDPYovHz3WSRrlZnDtf3kR34A6i8/J3lrQfH QjhtnIJETZtKnBxFCpAj0TGLdIszw0qq/RlYJxG8wJN18x2pMPJWXIWrskR5Wh9huc2L E+HIWSJnJ1h6PtQUXioCtZSWwkvenpVfElDQA= MIME-Version: 1.0 Received: by 10.100.154.13 with HTTP; Wed, 14 Apr 2010 02:12:54 -0700 (PDT) In-Reply-To: <1271235488423-1839484.post@n4.nabble.com> References: <1271232828988-1839436.post@n4.nabble.com> <1271235488423-1839484.post@n4.nabble.com> Date: Wed, 14 Apr 2010 11:12:54 +0200 Received: by 10.101.137.22 with SMTP id p22mr12335773ann.247.1271236374459; Wed, 14 Apr 2010 02:12:54 -0700 (PDT) Message-ID: Subject: Re: NodeIterator.getSize() returns -1 for query with order by clause From: Jacco van Weert <1111software@gmail.com> To: users@jackrabbit.apache.org Content-Type: multipart/alternative; boundary=0016e6d2832286ad1104842ec8e5 X-Virus-Checked: Checked by ClamAV on apache.org --0016e6d2832286ad1104842ec8e5 Content-Type: text/plain; charset=ISO-8859-1 See this thread for some answers http://n4.nabble.com/Queries-not-working-in-Jackrabbit-2-0-td1558394.html On Wed, Apr 14, 2010 at 10:58 AM, Gadbury wrote: > > To make things a little more simple, I have been experimenting with smaller > queries that do not use joins. > > 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. > > Why when I supply the property constraint is nodeIterator.getSize() > returning -1? > -- > View this message in context: > http://n4.nabble.com/NodeIterator-getSize-returns-1-for-query-with-order-by-clause-tp1839436p1839484.html > Sent from the Jackrabbit - Users mailing list archive at Nabble.com. > -- ------------------------------------- Jacco van Weert -- 1111software@gmail.com JCR Controller -- http://www.xs4all.nl/~weertj/jcr JeCARS -- http://code.google.com/p/jecars/ --0016e6d2832286ad1104842ec8e5--