JCR query fails when filtering through more than 25 results

[Ana Osman]

Hello,

JCR querries which should return more than 25 results fail when filters 
are applied.

Working queries:

SELECT * FROM nt:base WHERE (jcr:primaryType = 'mgnl:contentNode' OR 
jcr:primaryType = 'mgnl:content') AND name <> 'description_files' AND 
year<'2003' AND jcr:path LIKE '/wsDocumentList/Board-of-Directors/%' 
ORDER BY name asc
->this one is OK; it returns 25 results

SELECT * FROM nt:base WHERE (jcr:primaryType = 'mgnl:contentNode' OR 
jcr:primaryType = 'mgnl:content') AND name <> 'description_files' AND 
year<='2002' AND jcr:path LIKE '/wsDocumentList/Board-of-Directors/%' 
ORDER BY name asc
-> this one is OK; it return 25 results, so the "<=" comparator is not a 
problem

SELECT * FROM nt:base WHERE jcr:path LIKE 
'/wsDocumentList/Board-of-Directors/%'
-> this one returns 485 results, but it doesn't have any other filter 
except "jcr:path LIKE"


Not working queries:

SELECT * FROM nt:base WHERE (jcr:primaryType = 'mgnl:contentNode' OR 
jcr:primaryType = 'mgnl:content') AND name <> 'description_files' AND 
year<='2003' AND jcr:path LIKE '/wsDocumentList/Board-of-Directors/%' 
ORDER BY name asc
-> this should return 63 results, but is not returning anything...


We are using jackrabbit version 1.6.0. Any ideea why the filtering is 
causing problems when dealing with more results? Any ideea how should we 
fix this problem?

Many thanks,
Ana Osman