[OAK-9478] Implement support for BETWEEN operator

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.40.0
• Component/s: indexing
• Assignee: Unassigned
• Reporter: Amrit Verma
• Created: 30/Jun/21 08:38
• Updated: 30/Jun/21 08:39

Description

For multivalued properties, the current support of '<' and '>' operators is not sufficient. For example, if we look at the below query -

select * from [app:Asset] where isdescendantnode("/content") and [code] >= 1080 and [code] < 2000 

where code is a multivalued Long property, the search results would contain a node which has code set to [1060, 2030, 3010] . This node is returned because it contains values in both the ranges i.e. 1060 < 2000 and 2030 > 1080. So both conditions specified in the query are satisfied. 

What we actually want here that a node should be returned only if at least one value satisifies both the range conditions. 

For this we need support for BETWEEN operator.