Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-1986

Elaborate on case sensitivity in database names

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • 01112017-cleanup
    • None
    • Server
    • None

    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.

      Attachments

        Activity

          People

            sam.kleinman Sam Kleinman (Inactive)
            joanna.cheng@mongodb.com Joanna Cheng
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              10 years, 21 weeks, 1 day ago