[#MBS-3541] /ws/1 artist lookup returns odd release-group-list and omits releases from release-list - MusicBrainz JIRA

MusicBrainz Server

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

Created: 27/Sep/11 01:11 PM Updated: 03/Sep/12 10:34 AM Resolved: 03/Sep/12 10:34 AM

Component/s:

Web service

Affects Version/s:

None

Fix Version/s:

Bug fixes, 2012-09-03

Description

« Hide

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

Description

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

Show »

Sort Order:

[ Permalink | « Hide ]

voiceinsideyou added a comment - 28/Sep/11 09:38 AM

I'm a bit confused about this one actually. The same query on http://classic.musicbrainz.org/ws/1/artist/b10bbbfc-cf9e-42e0-be17-e2c3e1d2600d/?type=xml&inc=release-groups+sa-Official doesn't return any release-group-list so not sure why it's doing so on NGS...

[ Permalink | « Hide ]

Oliver Charles added a comment - 28/Sep/11 11:13 AM - edited

Nice find voice, I don't think it should be a list, as releases only have one release group

Edit: never mind, I thought you meant in <release> elements, but now I see it's a separate element entirely. Very odd, and certainly shouldn't be there!

[ Permalink | « Hide ]

Oliver Charles added a comment - 13/Aug/12 04:43 PM

In review with http://codereview.musicbrainz.org/r/2153/