Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-13964

Some recordings are missing a first release date

XMLWordPrintable

      For example, https://musicbrainz.org/recording/27aaf548-fb65-4e71-9e63-525414b7d3c3 should have a first-release-date of 2006-09-22 (but I can provide approximately 20,404 other examples).

          [MBS-13964] Some recordings are missing a first release date

          Michael Wiencek added a comment -

          Description of schema changes:

          1. A new function and corresponding trigger will be created on the medium table: a_upd_medium_mirror. As the name implies, the function and trigger will also be created on mirrors in order to keep the materialized recording_first_release_date table up-to-date.
          2. The recording_first_release_date table will be recalculated to fix existing entries.

          Michael Wiencek added a comment - Description of schema changes: A new function and corresponding trigger will be created on the medium table: a_upd_medium_mirror . As the name implies, the function and trigger will also be created on mirrors in order to keep the materialized recording_first_release_date table up-to-date. The recording_first_release_date table will be recalculated to fix existing entries.
          Michael Wiencek made changes -
          Fix Version/s New: Schema change, 2025 Q2 [ 13013 ]
          Michael Wiencek made changes -
          Assignee New: Michael Wiencek [ bitmap ]
          Michael Wiencek created issue -

            bitmap Michael Wiencek
            bitmap Michael Wiencek
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:

                Version Package
                Schema change, 2025 Q2