[OAK-5897] Optimize like constraint support in Property Indexes

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: property-index
• Assignee: Thomas Mueller
• Reporter: Chetan Mehrotra
• Created: 07/Mar/17 10:37
• Updated: 26/May/21 14:52

Description

Consider a query

 /jcr:root/content//element(*, nt:unstructured)[jcr:like(@resource, '/content/foo/bar%')]

This currently gets translated into a range property restriction

 property=[resource=[[/content/foo/bar.., ../content/foo/bas]]]

For such a query property index currently returns all nodes having "resource" property i.e. all index data. This can be optimized to return only those nodes where indexed value qualifies the range property restriction