[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: |
|
||||
| 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. |