Uploaded image for project: 'MusicBrainz Search Server'
  1. MusicBrainz Search Server
  2. SEARCH-318

Update indexing for _name table removal

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2013-10-14
    • Labels:
      None

      Description

      This should be fairly straightforward (just selecting from release.name instead of joining release_name and using release_name.name, for example); the basic bits of the schema and such are in the schema-changes-2013-10-15 branch now; the remaining review is for the pgtap tests and for reports, neither of which should affect search. Across the board, the rule is that columns that formerly referenced any of the _name tables, as integers, are now varchar columns holding the actual name.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ijabz Paul Taylor
                Reporter:
                ianmcorvidae Ian McEwen
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  2013-10-14