Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-14063

Update scripts do not fix relationship indexes

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: OpenIDM 6.0.0, 6.0.0.1, 6.0.0.2, 6.0.0.3, 6.0.0.4, 6.0.0.5, 6.0.0.6
    • Fix Version/s: None
    • Labels:

      Description

      Versions of IDM prior to 6.0 have this index defined on the "relationships" table:

      CREATE INDEX idx_json_relationships ON openidm.relationships ( json_extract_path_text(fullobject, 'firstId'), json_extract_path_text(fullobject, 'firstPropertyName'), json_extract_path_text(fullobject, 'secondId'), json_extract_path_text(fullobject, 'secondPropertyName') );
      

      In 6.0.0, the openidm repo initialization script redefines this index like so:

      CREATE INDEX idx_json_relationships ON openidm.relationships ( json_extract_path_text(fullobject, 'firstResourceCollection'), json_extract_path_text(fullobject, 'firstResourceId'), json_extract_path_text(fullobject, 'firstPropertyName'), json_extract_path_text(fullobject, 'secondResourceCollection'), json_extract_path_text(fullobject, 'secondResourceId'), json_extract_path_text(fullobject, 'secondPropertyName') );
      

      6.0.0 also provides a "hybridize" update script which alters the relationships table and adds two more indexes. However, it does not update the definition for this index. As a result, the relationships table does not get indexed for proper usage. Anyone upgrading to 6.0 (or beyond) needs to make sure to fix this index.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              matthias.grabiak Matthias Grabiak
              Reporter:
              jake.feasel Jake Feasel
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: