]> git.evergreen-ils.org Git - Evergreen.git/commit
LP1384796: Fix asset.copy_template valid_fine_level constraint
authorJason Stephenson <jason@sigio.com>
Thu, 28 Dec 2023 15:29:49 +0000 (10:29 -0500)
committerGalen Charlton <gmc@equinoxOLI.org>
Wed, 3 Jan 2024 14:57:54 +0000 (09:57 -0500)
commit226b43bab0b3c04f776b464d0ab4958944c404a0
treeca82699fcf192333a4e346b944cadc1344e1ab97
parenta77c799875e6218ecb36ddc2e445c029816fc2ea
LP1384796: Fix asset.copy_template valid_fine_level constraint

The "valid_fine_level" constraint on the asset.copy_template has been
erroneously defined to check the load_duration column.  This commit
fixes it so that the constraint looks at the fine_level column as it
should.

This commit adds the database upgrade, a miscellaneous release note,
as well as the main schema change.

To test the patch, simply look at the asset.copy_template table in the
database before and after applying the database upgrade.  The
valid_fine_level constraint should reference the fine_level column
after the patch.

The code is based on a patch submitted by Tim Faile.

Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Jane Sandberg <js7389@princeton.edu>
Signed-off-by: Galen Charlton <gmc@equinoxOLI.org>
Open-ILS/src/sql/Pg/040.schema.asset.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.copy_template_fine_level_constaint.sql [new file with mode: 0644]
docs/RELEASE_NOTES_NEXT/miscellaneous.adoc