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

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

      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.

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

              Created:
              Updated:
              Resolved:
              12 weeks, 1 day ago