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

/ws/1 artist lookup returns odd release-group-list and omits releases from release-list

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Bug fixes, 2012-09-03
    • Component/s: Web service
    • Labels:
      None

      Description

      There are some release_groups without a release at the end of http://musicbrainz.org/ws/1/artist/b10bbbfc-cf9e-42e0-be17-e2c3e1d2600d/?type=xml&inc=release-groups+sa-Official . For example, the release_group a79a5dc0-1731-373d-bbf9-33171b9b323a ("The Capitol Albums, Volume 1"), even though the corresponding release exists and fits all search criteria:

      select st.name, release.release_group, name.name, release.gid, release.id from release_name as name left join release as release on release.name=name.id left join release_status as st on st.id=release.status where name.name like '%The Capitol Albums%';
         name    | release_group |                               name                               |                 gid                  |   id   
      -----------+---------------+------------------------------------------------------------------+--------------------------------------+--------
                 |               | The Capitol Albums, Volume 1 (disc 2: The Beatles' Second Album) |                                      |       
                 |               | The Capitol Albums, Volume 1 (disc 3: Something New)             |                                      |       
                 |               | The Capitol Albums, Volume 2 (disc 1: The Early Beatles)         |                                      |       
                 |               | The Capitol Albums, Volume 2 (disc 2: Beatles VI)                |                                      |       
                 |               | The Capitol Albums, Volume 2 (disc 4: Rubber Soul)               |                                      |       
                 |               | The Capitol Albums, Volume 1 (disc 4: Beatles '65)               |                                      |       
       Official  |        281543 | The Capitol Albums, Volume 1                                     | 8ed9bdd4-66e8-4b7e-b5d3-59e623d56e4f |  16953
       Official  |        503532 | The Capitol Albums, Volume 2                                     | 3640493f-d9a1-45dd-b8a7-5a6f152ffb76 | 133198
                 |               | The Capitol Albums, Volume 1 (disc 1: Meet the Beatles!)         |                                      |       
       Promotion |        317797 | The Capitol Albums, Volume 1 Sampler                             | 893c55fb-4eef-484e-9b8d-a648f4fbfa3a | 953410
                 |               | The Capitol Albums, Volume 2 (disc 3: Help!)                     |                                      |       
      (11 Zeilen)
      
      musicbrainz_db=> select * from release_group where gid='a79a5dc0-1731-373d-bbf9-33171b9b323a';
         id   |                 gid                  |  name  | artist_credit | type | comment | edits_pending |         last_updated          
      --------+--------------------------------------+--------+---------------+------+---------+---------------+-------------------------------
       281543 | a79a5dc0-1731-373d-bbf9-33171b9b323a | 419815 |           303 |    1 |         |             0 | 2011-07-30 17:24:38.922968+02
      
      

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                Bug fixes, 2012-09-03