[GEODE-9018] ExtendedNumericComparator does not compare correctly NULL and UNDEFINED

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Component/s: querying
• Labels: pull-request-available
• Assignee: Alberto Gomez
• Reporter: Alberto Gomez
• Created: 10/Mar/21 16:15
• Updated: 22/Jun/22 20:46
• Resolved: 25/Mar/21 11:47

Description

The compareTo method of ExtendedNumericComparator does not compare correctly UNDEFINED and NULL.

UNDEFINED should always be smaller than anything but it is not always so when compared with NULL.

compareTo(NULL, UNDEFINED) returns 1, which is correct

but

compareTo(UNDEFINED, NULL) returns 1, and it should return -1.

This could provoke that queries with indexes do not return the right results when these values are involved.

Issue Links

• links to: GitHub Pull Request #6110