Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-8266

Make medium titles VARCHAR NOT NULL

    XMLWordPrintable

    Details

      Description

      The titles for individual mediums of a release are defined as VARCHAR(255) and can be NULL. This is inconsistent with other cases of optional string values, where the empty string is used to indicate the absence of a value (e.g., disambiguation comment on all types of entities, address for places); there is also no semantic distinction that could be expressed by a NULL value as opposed to an empty string. Further, this is inconsistent with other entity names, which are VARCHAR without a length limit.

      Therefore,

      • all existing NULL medium titles should be updated to the empty string,
      • the definition for medium.name should be changed to VARCHAR NOT NULL DEFAULT ''.

      Currently, there are 1522931 mediums with a NULL title and 3224 mediums with a title that is the empty string; this is because those 3224 mediums were added by Likedis Auto.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                chirlu Ulrich Klauer
                Reporter:
                chirlu Ulrich Klauer
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  Schema change, 2015-05-18