[SERVER-44376] Indexed $gte/lte does not produce superset of results returned by $eq for 'undefined' values Created: 01/Nov/19 Updated: 27/Oct/23 Resolved: 16/Nov/19 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Ian Boros | Assignee: | Ian Boros |
| Resolution: | Gone away | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Operating System: | ALL | ||||||||
| Sprint: | Query 2019-12-02 | ||||||||
| Participants: | |||||||||
| Description |
|
{$eq: null} returns true for missing, null and undefined values. Our index bounds generation does not include 'undefined' for predicates like {$gte: null} (or $lte).
|
| Comments |
| Comment by Ian Boros [ 16/Nov/19 ] |
|
Fixed under |
| Comment by David Storch [ 04/Nov/19 ] |
|
ian.boros, I'm flagging this for scheduling, since in general new ticket should not go directly to the backlog. |