-
Bug
-
Resolution: Fixed
-
Normal
-
None
-
None
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