[
https://issues.apache.org/jira/browse/SLING-11439?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17564278#comment-17564278
]
Julian Reschke edited comment on SLING-11439 at 7/8/22 12:54 PM:
-----------------------------------------------------------------
Ok, this one
{noformat}
select * from [nt:base] where [sling:vanityPath] >= "" order by
[sling:vanityPath] option (limit 1000)
{noformat}
seems to work as SQL2 query (and the ">=" would be used to select the query
start)
was (Author: reschke):
Ok, this one
{noformat}
select * from [nt:base] where [sling:vanityPath] >= "" order by
[sling:vanityPath] option (limit 1000)
{noformat}
seems to work as SQL2 query.
> resource resolver: fails to detect aborted vanity path query
> ------------------------------------------------------------
>
> Key: SLING-11439
> URL: https://issues.apache.org/jira/browse/SLING-11439
> Project: Sling
> Issue Type: Bug
> Components: ResourceResolver
> Reporter: Julian Reschke
> Priority: Major
>
> With the introduction of the Oak query limit, JCR queries may get aborted
> when the result set size exceeds a certain value (currently by default
> 100000).
> However:
> https://github.com/apache/sling-org-apache-sling-jcr-resource/blob/604332e9be17378276685033bdbce54994dad8c1/src/main/java/org/apache/sling/jcr/resource/internal/helper/jcr/JcrNodeResourceIterator.java#L115-L134
> So Apache Sling JCR Resource's API hides that exception, and thus resource
> resolver will happily startup with an incomplete cache.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
