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

work_attribute check is wrong

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2013-11-11
    • Component/s: None
    • Labels:
      None

      Description

      The work_attribute table has the following in CreateTables:

      -- Either it has a value from the allowed list, or is free text
      CHECK ( work_attribute_type_allowed_value IS NULL OR work_attribute_text IS NULL )
      

      However, that check does not achieve what the comment asks for (because it's possible for both to be null).

        Attachments

          Activity

            People

            • Assignee:
              acid2 Oliver Charles
              Reporter:
              acid2 Oliver Charles
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2013-11-11