Issue Details (XML | Word | Printable)

Key: MBS-5770
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Normal Normal
Assignee: Oliver Charles
Reporter: Oliver Charles
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
MusicBrainz Server

There is no constraint on release_label that either (or both) the label or catalog number are not null.

Created: 22/Jan/13 05:50 PM   Updated: 19/Apr/13 06:31 AM   Resolved: 11/Feb/13 11:40 AM
Component/s: None
Affects Version/s: None
Fix Version/s: 2013-02-11

 Description  « Hide

We currently have 76 rows where there is nothing useful at all:

musicbrainz_db_20110516=> select count(*) from release_label where label is null and catalog_number is null;                                                                                                                                  
(1 row)

Sort Order: Ascending order - Click to sort in descending order
Oliver Charles added a comment - 25/Jan/13 11:32 AM

Ian McEwen added a comment - 19/Apr/13 06:31 AM

Apparently the upgrade script from this was not run, and so CreateConstraints was failing on our full-import tests. I've now run it, so as of the next dump those should stop being a problem.