jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clemens Wyss <clemens...@mysign.ch>
Subject JCR-SQL2 : no count when WHERE clause is provided
Date Thu, 30 Sep 2010 09:55:11 GMT
Hi all,
on the sling mailinglist (http://mail-archives.apache.org/mod_mbox/sling-users/201009.mbox/%3C4CA4457A.9010006@gmail.com%3E)
we have been discussing the follwoing issue:

whenever you provide a where-clause to a sql2 select, jcr/jackrabbit does not provide the
hit count.

   select * from [nt:unstructured]
   order by [jcr:score]
returns the hit count (query.execute().getRows().getSize()), whereas
  select * from [nt:unstructured]
  where entity = "customer"
  order by [jcr:score]
Is this a bug or a feature?

Thx in advance

View raw message