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

Make regex use collation index

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Works as Designed
    • Icon: Major - P3 Major - P3
    • None
    • None
    • Querying
    • None
    • Query

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: