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

Make regex use collation index

    • Type: Icon: Improvement Improvement
    • Resolution: Works as Designed
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Querying
    • Labels:
      None
    • Query

      Case insensitive indexes should be used when running a case insensitive "starts with" regex like this /^searchterm/i

      Currently if you make a case insensitive collation and run a "starts with" regex query like this /^searchterm/i, mongodb will not use the index. This is a real problem for any application that uses an autocomplete feature.

            Assignee:
            backlog-server-query Backlog - Query Team (Inactive)
            Reporter:
            dane@turbobuilt.com dane truelson
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: