Uploaded image for project: 'FOLIO'
  1. FOLIO
  2. FOLIO-2254

Remove outdated indexes on jsonb->>'foreignKeyId' field

    XMLWordPrintable

Details

    • CP: sprint 78
    • 0
    • Core: Platform

    Description

      Once RMB-468 is implemented, we should consider to clean up existing indexes on jsonb->>'foreignKeyId' field
      For example: https://github.com/folio-org/mod-inventory-storage/blob/v17.0.0/src/main/resources/templates/db_scripts/schema.json#L688

            "tableName": "holdings_record",
            "ginIndex": [
              {
                "fieldName": "instanceId",
                "tOps": "ADD",
                "caseSensitive": false,
                "removeAccents": true
              },
              {
                "fieldName": "permanentLocationId",
                "tOps": "ADD",
                "caseSensitive": false,
                "removeAccents": true
              },
              {
                "fieldName": "temporaryLocationId",
                "tOps": "ADD",
                "caseSensitive": false,
                "removeAccents": true
              }
            ]
      

      We have tickets for individual modules, so this becomes an umbrella ticket. We should skip scoring this one and close it once all module tickets are completed.

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                hji Hongwei Ji
                hji Hongwei Ji
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases