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

Positional projection queries (and positional update ops) should fail with error if multiple arrays encountered

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major - P3
    • Resolution: Won't Fix
    • None
    • None
    • Querying
    • None
    • Query 10 (02/22/16)

    Description

      Running the following commands on 2.6 and 2.4 gives different output when running following commands:

      db.createCollection("PositionalOperatorRepro")
      		 
      db.PositionalOperatorRepro.insert({"_id": "test1",  "Items": [ { "Id": 1 }, { "Id": 2 }  ] })
      		 
      db.PositionalOperatorRepro.find({ "_id" : "test1", "Items" : { "$exists" : true, "$elemMatch" : { "Id" : 2 } } } , { "Items.$" : 1 })


      // 2.4 returns
      		 
      {.. Items: [{Id:2}]}
      		 
      // 2.6 returns
      		 
      {.. Items: [{Id:1}]}
      		 
      // 2.6 without $exists
      		 
      {.. Items: [{Id:2}]}

      If we remove the "$exists" : true criteria the output will be the same.

      Is this change documented anywhere? There could be compatibility issues when upgrading.

      I'm attaching a screen shot where I reproduced this behavior.

      Attachments

        1. match_expr.png
          match_expr.png
          64 kB
        2. repro.png
          repro.png
          39 kB

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. SERVER-17159 $ Positional Operator Only Updating First Sub-Document

          • Critical - P2 - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-1013 positional $ operator field mismatch

          • Major - P3 - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-11537 Incosistent behavior with $or and $elemMatch

          • Major - P3 - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-14837 Positional Operator matching wrong nested document

          • Major - P3 - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-16409 Updates against paths composed with array index notation and positional operator can insert an embedded document

          • Major - P3 - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-17999 Regression between MongoDB 2.4 and 2.6

          • Major - P3 - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-41382 Update in nested array based on Date queries may not work properly

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-16888 $ positional operator with $elemMatch doesn't work when multiple update critera supplied

          • Critical - P2 - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-11537 Incosistent behavior with $or and $elemMatch

          • Major - P3 - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. SERVER-21794 Array field limitation in query document [Only one array field may appear in the query document.]

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-18500 Resolve ambiguity of positional projections with multiple implicit array traversal predicates in certain cases

          • Major - P3 - Major loss of function.
          • Backlog
          related to

          Task - A task that needs to be done. DOCS-12773 Explicitly refer to "Single Field Matches" for positional "$ (update)" operator

          • Major - P3 - Major loss of function.
          • Closed

          Task - A task that needs to be done. SERVER-27088 Revert changes to positional projections and positional updates in 3.4

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DOCS-3874 Add warning about undefined behavior cases for positional projection operator ($)

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              tess.avitabile@mongodb.com Tess Avitabile (Inactive)
              jracabado João Acabado
              Votes:
              5 Vote for this issue
              Watchers:
              23 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: