[DOCS-16615] [Server] inconsistent information regarding $regex operator and case-insensitive indexes Created: 30/Jan/24  Updated: 01/Feb/24  Resolved: 01/Feb/24

Status: Closed
Project: Documentation
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task Priority: Critical - P2
Reporter: Marina Sirota Assignee: Jeffrey Allen
Resolution: Fixed Votes: 0
Labels: top250
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
URL(s): https://www.mongodb.com/docs/manual/core/index-case-insensitive/
https://www.mongodb.com/docs/manual/reference/operator/query/regex/
Participants:
Days since reply: 6 days ago

 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.



 Comments   
Comment by Jeffrey Allen [ 01/Feb/24 ]

Closing this ticket as the server docs updates have been addressed. Atlas docs updates are being tracked in DOCSP-36137.

Generated at Thu Feb 08 08:15:45 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.