[SERVER-36609] Modify allPaths indexes to support equality to empty array Created: 13/Aug/18  Updated: 29/Oct/23  Resolved: 26/Sep/18

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: 4.1.3

Type: Task Priority: Major - P3
Reporter: Ian Boros Assignee: Yuta Arai
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-36109 Provide planner with multikeyness inf... Closed
Backwards Compatibility: Fully Compatible
Sprint: Query 2018-10-08
Participants:

 Description   

When check if something is equal to an empty array, the planner currently builds the following bounds:

[[undefined, undefined], [[], []]]

This should "just work" with a $** index, but we should check to be sure.



 Comments   
Comment by Githook User [ 26/Sep/18 ]

Author:

{'name': 'yarai', 'email': 'yuta.arai@10gen.com', 'username': 'yarai'}

Message: SERVER-36609 Modify allPaths indexes to support equality to empty array
Branch: master
https://github.com/mongodb/mongo/commit/54d601d3fd7297f71380178ee34029479edea944

Comment by Ian Boros [ 12/Sep/18 ]

If we don't get to this, we should re-check some of the code in the plan cache discriminators which might treat equality to [] as supported by the index.

Comment by Ian Boros [ 27/Aug/18 ]

david.storch I filed SERVER-36896.

Comment by David Storch [ 27/Aug/18 ]

ian.boros, should we have a separate ticket for equality to empty object?

Comment by Ian Boros [ 21/Aug/18 ]

Should also check that this works with equality to empty object, if we want to support that.

We may need to update the plan cache discriminators as part of this ticket, so I do not believe that this will "just work" any more.

Generated at Thu Feb 08 04:43:37 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.