[OAK-10033] Conditions on dates use the wrong range

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.48.0
• Assignee: Mohit Kataria
• Reporter: Mohit Kataria
• Created: 16/Dec/22 08:48
• Updated: 27/Jan/23 11:42
• Resolved: 18/Jan/23 15:18

Description

For queries like:
SELECT * FROM [nt:base] AS main WHERE (main.[startTime] <> cast('1971-01-01T13:00:00.000Z' AS date))
The condition uses the wrong range, as negative values are possible. The range should be -9223372036854775808 TO 9223372036854775807 and not 0 TO 9223372036854775807.

[calendar@startTime] <> cast('1971-01-01T13:00:00.000Z' AS date)
+calendar@startTime:[0 TO 9223372036854775807] -calendar@startTime:[31582800000 TO 31582800000]

Source code:
https://github.com/apache/jackrabbit-oak/blob/trunk/oak-core/src/main/java/org/apache/jackrabbit/oak/query/ast/PropertyValueImpl.java

https://github.com/apache/jackrabbit-oak/blob/trunk/oak-lucene/src/main/java/org/apache/jackrabbit/oak/plugins/index/lucene/LucenePropertyIndex.java#L1227

// not null. For date lower bound of zero can be used
return NumericRangeQuery.newLongRange(propertyName, 0L, Long.MAX_VALUE, true, true);

This isn't correct, as 0 means 1970-01-01T00:00:00.000Z

It should probably be :

// not null. For date lower bound of zero can be used
return NumericRangeQuery.newLongRange(propertyName, Long.MIN_VALUE, Long.MAX_VALUE, true, true);

Issue Links

• links to: GitHub Pull Request #795