FInd using a boxed match causes full index scan

XMLWordPrintableJSON

    • Type: Question
    • Resolution: Done
    • Priority: Trivial - P5
    • None
    • Affects Version/s: None
    • Component/s: Querying
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      If I run this find query:

      db.data.findOne({G:/^[W]/})

      I get a full index scan being performed.
      explained as :

         "indexBounds" : {
           "G" : [
                   "[\"\", {})",
                   "[/^[W]/, /^[W]/]"
           ],

            Assignee:
            Sam Kleinman (Inactive)
            Reporter:
            Paul Reed
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: