[#MBS-5475] migration on 8.4 is broken - MusicBrainz JIRA

MusicBrainz Server

migration on 8.4 is broken

Created: 17/Oct/12 04:24 PM Updated: 23/Nov/12 08:38 PM Resolved: 23/Nov/12 08:38 PM

Component/s:

Schema Change

Affects Version/s:

Schema change, 2012-10-15

Fix Version/s:

None

Description

« Hide

20110602-merge-duplicate-tracklists.sql contains several clauses that use ORDER BY inside of array_agg():

SELECT array_agg(tracklist ORDER BY tracklist ASC) AS all_merge

ORDER BY inside 8.4 is not supported and anyone using 8.4 (minimum supported version) can't upgrade. Please investigate a workaround that does not use ORDER BY. I'm guessing we need to create more temporary tables to accomplish this.

Sort Order:

[ Permalink | « Hide ]

Robert Kaye added a comment - 17/Oct/12 04:24 PM

Moving this to critical since it affects our customers.

Robert Kaye made changes - 17/Oct/12 04:24 PM

Field	Original Value	New Value
Priority	Normal [ 6 ]	Critical [ 2 ]

[ Permalink | « Hide ]

Ian McEwen added a comment - 23/Nov/12 08:38 PM

We determined this wouldn't be fixed, ref: blog.

Ian McEwen made changes - 23/Nov/12 08:38 PM

Status	Open [ 1 ]	Closed [ 6 ]
Assignee	Ian McEwen [ ianmcorvidae ]
Resolution		Won't Fix [ 2 ]