Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-16615

[Server] inconsistent information regarding $regex operator and case-insensitive indexes

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Fixed
    • Icon: Critical - P2 Critical - P2
    • None
    • None
    • None

    Description

      Dear all,

      Our documentation is proving inconsistent/contradictory  information regarding `$regex` operator and case-insensitive indexes:

       

      One: Case insensitive regular expression queries generally cannot use indexes effectively. The $regex implementation is not collation-aware and is unable to utilize case-insensitive indexes.

       

      Two:   If you frequently run case-insensitive regex queries (utilizing the i option), .....Alternatively, you can create a case-insensitive index to support your queries.* You can also specify a collation on an index to define language-specific rules for string comparison, such as rules for lettercase and accent marks.

       

      Thank you in advance for taking time and fixing this.

      Friendly regards,

      Marina.

      Attachments

        Activity

          People

            jeffrey.allen@mongodb.com Jeffrey Allen
            marina.sirota@mongodb.com Marina Sirota
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              6 days ago