Uploaded image for project: 'mod-inventory-storage'
  1. mod-inventory-storage
  2. MODINVSTOR-722

Remove update effective location database functions

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: P3
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 22.0.0
    • Labels:
      None
    • Template:
      Standard Bug Write-Up Format
    • Sprint:
      Prokopovych - Sprint 114, Prokopovych - Sprint 115, Prokopovych - Sprint 116, Prokopovych - Sprint 117, Prokopovych - Sprint 118, Prokopovych - Sprint 119, Prokopovych - Sprint 120, Prokopovych - Sprint 121, Prokopovych - Sprint 122
    • Story Points:
      3
    • Development Team:
      Prokopovych

      Description

      Overview:
      The following issue is observed in bugfest-iris.folio.ebsco.com environment.

      Functions update_effective_location_on_holding_update () and update_effective_location_on_item_update () are both present in bugfest iris db

      Bugfest-iris was updated from mod-inventory-storage-19.4.4 to mod-inventory-storage-20.2.1

      We compared db schema to a cleanly installed Iris environment db schema (environment was not upgraded)

      These functions do not exist in the cleanly installed environment

      Migration scripts should be put in place for cleanup of no longer needed functions.

      looks like triggers were removed but trigger functions still remain
      https://github.com/folio-org/mod-inventory-storage/blob/v20.2.1/src/main/resources/templates/db_scripts/dropLegacyItemEffectiveLocationTriggers.sql

      Expected Results:
      Functions update_effective_location_on_holding_update () and update_effective_location_on_item_update () are removed as part of module upgrade
      Actual Results:
      Functions are present in upgraded environment
      Additional Information:
      URL:
      Interested parties:

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                felkerk Kyle Felker
                Reporter:
                cgodfrey Carole Godfrey
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases