[mb-commits] branch, beta, updated. MBS-5652: use a left join so label-less catalog numbers still work correctly

The branch, beta has been updated
       via  http://git.musicbrainz.org/gitweb/?p=musicbrainz-server/core.git;a=commit;h=2b87e4dcb6036ad32ea2cb5da386a1ca2e6ff61f (commit)
      from  http://git.musicbrainz.org/gitweb/?p=musicbrainz-server/core.git;a=commit;h=48dff89585a1e0b874458fec045f09d6b94feb7c (commit)

Summary of changes:
 lib/MusicBrainz/Server/Data/ReleaseLabel.pm |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 2b87e4dcb6036ad32ea2cb5da386a1ca2e6ff61f
Author: Ian McEwen <[email protected]>
Date:   Tue Jan 15 13:49:58 2013 -0700

    MBS-5652: use a left join so label-less catalog numbers still work correctly

diff --git a/lib/MusicBrainz/Server/Data/ReleaseLabel.pm b/lib/MusicBrainz/Server/Data/ReleaseLabel.pm
index 15d157c..b49a071 100644
--- a/lib/MusicBrainz/Server/Data/ReleaseLabel.pm
+++ b/lib/MusicBrainz/Server/Data/ReleaseLabel.pm
@@ -48,8 +48,8 @@ sub load
     return unless @ids; # nothing to do
     my $query = "SELECT " . $self->_columns . "
                  FROM " . $self->_table . "
-                 JOIN label ON rl.label = label.id
-                 JOIN label_name sort_name ON label.sort_name = sort_name.id
+                 LEFT JOIN label ON rl.label = label.id
+                 LEFT JOIN label_name sort_name ON label.sort_name = sort_name.id
                  WHERE release IN (" . placeholders(@ids) . ")
                  ORDER BY release, rl_catalog_number, musicbrainz_collate(sort_name.name)";
     my @labels = query_to_list($self->c->sql, sub { $self->_new_from_row(@_) },

-----------------------------------------------------------------------


hooks/post-receive
-- 
mb_server