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

Queries with dotted notation create invalid dotted keys in system.profile

    • Type: Icon: Task Task
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 2.0.7, 2.2.0
    • Component/s: Querying
    • Labels:
      None

      Queries using dotted notation can create a query key in system.profile which includes a dot (illegal according to: http://www.mongodb.org/display/DOCS/Legal+Key+Names).

      Example set up:

      db.setProfilingLevel(2);
      db.books.insert({protagonist: "Guy Montog", antecedents: 
        [{title: "The Fireman"}, {title: "Bright Phoenix"}]});
      db.books.find({"antecedents.title": "The Fireman"})
      

      Entry in profile collection for the query:

      		{
      			"ts" : ISODate("2012-10-14T01:34:07.057Z"),
      			"op" : "query",
      			"ns" : "dotted.books",
      			"query" : {
      				"antecedents.title" : "The Fireman"
      			},
      			"nscanned" : 2,
      			"nreturned" : 2,
      			"responseLength" : 286,
      			"millis" : 0,
      			"client" : "127.0.0.1",
      			"user" : ""
      		}
      

      This makes it difficult to find profile entries for dotted queries.

            Assignee:
            Unassigned Unassigned
            Reporter:
            stephen.steneker@mongodb.com Stennie Steneker (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: