Issue with database migration for Iris release

Description

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

Trigger function - recalculate_totals() is present in bugfest-iris db
We compared db to a freshly installed Iris environment db in which this function does not exist.

Function should have been removed when bugfest-honeysuckle was upgraded to bugfest-iris
https://folio-org.atlassian.net/browse/MODFISTO-181
https://github.com/folio-org/mod-finance-storage/pull/165/files

Initial Version upgrade from mod-finance-storage-6.0.1 to mod-finance-storage-7.0.1 and then to 7.0.1

Expected Results:
recalculate_totals() function is removed as part of upgrade
Actual Results:
recalculate_totals() function is present after the upgrade

Note – module version prior to upgrade
mod-finance-storage-6.0.1

Observe references to "fromModuleVersion": "mod-finance-storage-6.1.0" in code

Environment

None

Potential Workaround

None

Attachments

4

Checklist

hide

TestRail: Results

Activity

Show:

Andrei Makaranka June 14, 2021 at 9:08 AM

Verified locally by

Function was removed

Yauheni Kuzmianok June 3, 2021 at 1:29 PM

Verified via vagrant box 

After installing 
mod-finance-storage-6.0.1

After update to mod-finance-storage-7.1.0-SNAPSHOT.182

Yauheni Kuzmianok April 28, 2021 at 1:34 PM

Looks like existing trigger function recalculate_totals()  should not affect anything as we removed trigger but function still in place

Done

Details

Assignee

Reporter

Tester Assignee

Priority

Story Points

Sprint

Development Team

Thunderjet

Fix versions

Release

R2 2021

Affects versions

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created April 26, 2021 at 9:17 PM
Updated June 14, 2021 at 9:08 AM
Resolved June 14, 2021 at 9:08 AM
TestRail: Cases
TestRail: Runs