Author: robert
Date: 2009-06-30 19:59:45 +0000 (Tue, 30 Jun 2009)
New Revision: 11797
Modified:
mb_server/trunk/admin/sql/updates/ngs.sql
Log:
Use the lowest rowid to to assign old release ids to, rather than earliest release date.
Modified: mb_server/trunk/admin/sql/updates/ngs.sql
===================================================================
--- mb_server/trunk/admin/sql/updates/ngs.sql 2009-06-29 20:41:43 UTC (rev 11796)
+++ mb_server/trunk/admin/sql/updates/ngs.sql 2009-06-30 19:59:45 UTC (rev 11797)
@@ -128,7 +128,7 @@
------------------------
-- Check which release events should get album GIDs (the earliest one from an album)
-SELECT gid::uuid, a.id AS album, (SELECT id FROM public.release r WHERE a.id=r.album ORDER BY releasedate LIMIT 1) AS id
+SELECT gid::uuid, a.id AS album, (SELECT min(id) FROM public.release r WHERE a.id=r.album) AS id
INTO TEMPORARY tmp_release_gid
FROM public.album a
WHERE EXISTS (SELECT id FROM public.release r WHERE r.album=a.id);
_______________________________________________
MusicBrainz-commits mailing list
MusicBrainz-commits@...
http://lists.musicbrainz.org/mailman/listinfo/musicbrainz-commits
