[DOCS-1986] Elaborate on case sensitivity in database names Created: 23/Sep/13  Updated: 11/Jan/17  Resolved: 24/Sep/13

Status: Closed
Project: Documentation
Component/s: Server
Affects Version/s: None
Fix Version/s: 01112017-cleanup

Type: Improvement Priority: Major - P3
Reporter: Joanna Cheng Assignee: Sam Kleinman (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to SERVER-10826 Assert in the secondary Closed
Participants:
Days since reply: 10 years, 21 weeks, 1 day ago

 Description   

From http://docs.mongodb.org/manual/reference/limits/

Naming Restrictions
Restrictions on Database Names
The dot (i.e. .) character is not permissible in database names.
 
Database names are case sensitive even if the underlying file system is case insensitive.

This is not as explicit as it could be:

  • It seems at the filesystem level, we always create files with the database name all in lowercase
    • So we cannot have a database named "test" and a database named "TEST" simultaneously, as they would map onto the same file
  • However, if we have a database "test" and we try and drop the database "TEST" via

    use TEST; db.dropDatabase()

    we get an error

    > db.dropDatabase()
    {
    	"assertion" : "db already exists with different case other: [mydb] me [myDB]",
    	"assertionCode" : 13297,
    	"errmsg" : "db assertion failure",
    	"ok" : 0
    }

I think it would be beneficial to show examples like the above, to make it clear when we are case-sensitive, and when we are case-insensitive, and the impacts.



 Comments   
Comment by auto [ 24/Sep/13 ]

Author:

{u'username': u'tychoish', u'name': u'Sam Kleinman', u'email': u'samk@10gen.com'}

Message: DOCS-1986: case sensitivity limitation in database names
Branch: master
https://github.com/mongodb/docs/commit/5dc5b1174d5121d5c1602dfa3f7a5a9dd452e0d1

Generated at Thu Feb 08 07:42:24 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.