[DOCS-13840] [SERVER] Database name case sensitivity possibly incorrect Created: 18/Aug/20 Updated: 30/Oct/23 Resolved: 10/Aug/22 |
|
| Status: | Closed |
| Project: | Documentation |
| Component/s: | manual, Server |
| Affects Version/s: | None |
| Fix Version/s: | Server_Docs_20231030 |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Matthew Chiaravalloti | Assignee: | Dave Cuthbert (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | needs-testing | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Participants: | |
| Days since reply: | 1 year, 26 weeks ago |
| Epic Link: | DOCSP-11701 |
| Description |
DescriptionThe docs for Database Name Case Sensitivity say: "Since database names are case insensitive in MongoDB, database names cannot differ only by the case of the characters." I have not been able to verify this using the mongodb go driver or the mongo shell. An informal discussion with a member of the query team led me to believe this may not be correct. I'm curious if this is platform dependent or possibly incorrect? I attempted to verify db name case-insensitivity using the go driver and mongo shell on a Mac. Scope of changesImpact to Other DocsMVP (Work and Date)Resources (Scope or Design Docs, Invision, etc.) |
| Comments |
| Comment by Githook User [ 10/Aug/22 ] |
|
Author: {'name': 'Dave Cuthbert', 'email': '69165704+davemungo@users.noreply.github.com', 'username': 'davemungo'}Message: |
| Comment by Githook User [ 10/Aug/22 ] |
|
Author: {'name': 'Dave Cuthbert', 'email': '69165704+davemungo@users.noreply.github.com', 'username': 'davemungo'}Message: |
| Comment by Geert Bosch [ 14/Oct/20 ] |
|
The issue for database names is that we have directory per DB, and some filesystems (such as on Windows, Mac) are case insensitive. We could have / should have properly normalized/escaped DB names, but we never did. So we check that we don't allow creation of two databases that only differ in name. Also on Windows we're more restrictive in allowed database names than on other systems. |
| Comment by Charlie Swanson [ 14/Oct/20 ] |
|
I would be surprised if database names are case insensitive, I have never heard of that. It sounds like it has already been tested so I haven't done my own. Perhaps someone from execution could confirm or knows any historical context. geert.bosch] can you confirm or know anyone who could? |
| Comment by Adinoyi Omuya [ 14/Oct/20 ] |
|
This is a pretty visible part of our documentation that we should clarify. CC charlie.swanson to verify the case sensitivity of MongoDB identifiers (database, collection, and field names). |