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

Aggregation pipeline cannot process system.profile doc fields with $ prefixes

    XMLWordPrintableJSON

Details

    • Query Optimization

    Description

      Due to strict FieldPath validation, aggregation pipelines cannot process fields that start with a $ character (commonly found in the system.profile collection).

      Steps to reproduce (copied here so code formatting works):

      db.system.profile.drop();
      		 
      db.setProfilingLevel(2);
      		 
      db.foo.update({},{$set:{x:1}})
      		 
      db.setProfilingLevel(0);
      		 
      db.system.profile.aggregate([
      		 
        { "$match" : {"op" : "update"}},
      		 
        { "$project" : {"set" : "$updateobj.$set"}}
      		 
      ]);

      Exception:

        "errmsg" : "exception: FieldPath field names may not start with '$'.",
      		 
        "code" : 16410,
      		 
        "ok" : 0

      Attachments

        Issue Links

          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. SERVER-13436 Allow creating/using dollar-sign prefixed field names

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

          Bug - A problem which impairs or prevents the functions of the product. SERVER-14466 Support projecting the $id or $ref for a DBRef() field

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-30575 Please add escaping convention for dot and dollar signs!

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-6592 improve FieldPath validation behavior

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

          New Feature - A new feature of the product, which has yet to be developed. SERVER-3943 $quote operator

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-14255 Allow storing aggregation pipelines as documents in MongoDB

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-30365 How to exclude (sub)fields starting with $ in a query projection

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

          Activity

            People

              backlog-query-optimization Backlog - Query Optimization
              jmikola@mongodb.com Jeremy Mikola
              Votes:
              3 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated: