[SERVER-77344] Improve precision of anyIndexesMightBeAffected Created: 22/May/23  Updated: 01/Aug/23

Status: Backlog
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Alberto Massari Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Tested
tested by SERVER-76533 Add unittest coverage for "indexes af... Closed
Assigned Teams:
Query Execution
Sprint: QE 2023-06-26, QE 2023-07-10, QE 2023-07-24
Participants:

 Description   

Enabling the unit tests for SERVER-65364 highlighted that the current detection logic based on diff objects returns a false positive in two situations (i.e. an index is marked as requiring an update even if the change is outside of the indexed paths).

Unit test: UpdateArrayNodeTest.NoArrayElementAffectsIndexes
Index path: a.c
Operation: set a.$[i].b

Unit test: SetNodeTest.ApplySetFieldInNonExistentNumericFieldDoesNotAffectIndexOnSiblingField
Index path: a.1.b
Operation: set a.1.c


Generated at Thu Feb 08 06:35:15 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.