Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-77344

Improve precision of anyIndexesMightBeAffected

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • QE 2023-06-26, QE 2023-07-10, QE 2023-07-24

      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

            Assignee:
            backlog-query-execution [DO NOT USE] Backlog - Query Execution
            Reporter:
            alberto.massari@mongodb.com Alberto Massari
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: