Update normalize_isbns to have full schema path (Quesnelia CSP)

Description

Given that a tenant has been freshly installed using Quesnelia. Then:

Database maintenance (VACUUM ANALYZE) fails.

Migration from PostgreSQL 12 to 16 fails.

Therefore we need to back-port from master/Ramsons to Quesnelia CSP.

CSP Request Details

1. Describe issue impact on business Database maintenance (VACUUM ANALYZE) fails. Migration from PostgreSQL 12 to 16 fails. 2. What institutions are affected? (field “Affected Institutions” in Jira to be populated) GBV Index Data (Lesley) 3. What is the workaround if exists? None. There's no other way than fixing the function in the database. 4. What areas will be impacted by fix (i.e. what areas need to be retested) It's a database index for requests, however, only database sysops can test whether the fix has been applied, the fix is non-testable in UI/in APIs. 5. Brief explanation of technical implementation and the level of effort (in workdays) and technical risk (low/medium/high) Revert CIRCSTORE-377. Then the database function will have the schema again. It will be reverted to the function code as it was in Poppy and before. Less than one workday effort. Low technical risk. 6. Brief explanation of testing required and level of effort (in workdays). Provide test plan agreed with by QA Manager and PO. Known to work because we revert to code we have had been using in Orchid and Poppy. Existing automated tests are sufficient to ensure that there are no regressions. Testing effort is less than a workday. 7. What is the roll back plan in case the fix does not work? If it causes major regressions we will create a new CSP with the revert of the revert.

CSP Rejection Details

None

Potential Workaround

None

Checklist

hide

Activity

Show:

Julian Ladisch January 24, 2025 at 11:41 AM

We’ve got CSP approval today.

Julian Ladisch January 20, 2025 at 10:05 AM

Blocked by outstanding CSP approval that has been requested in #release_bug_triage on 2025-01-09: https://folio-project.slack.com/archives/CHLD3AKU7/p1736441945643569

Done

Details

Assignee

Reporter

Priority

Development Team

Vega

Fix versions

Release

Quesnelia (R1 2024) Service Patch #9

RCA Group

Implementation coding issue

CSP Approved

Yes

Affected releases

Quesnelia (R1 2024)

Affected Institution

GBV
OTHER

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created January 9, 2025 at 1:26 PM
Updated January 24, 2025 at 11:42 AM
Resolved January 18, 2025 at 3:39 PM
TestRail: Cases
TestRail: Runs