Details
-
Task
-
Resolution: Fixed
-
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.