]> git.evergreen-ils.org Git - working/Evergreen.git/commit
projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 2605a9e) | patch
Lp 1922567: Limit authority.full_rec.value indexes
authorJason Stephenson <jason@sigio.com>
Tue, 6 Apr 2021 11:43:52 +0000 (07:43 -0400)
committerGalen Charlton <gmc@equinoxOLI.org>
Mon, 4 Oct 2021 14:52:55 +0000 (10:52 -0400)
commit38374b5a2add8172f1cebebf312ceaf0e5bf2a0d
tree1f71c3790bd5577f21c86da7d2be720b6ad5f3e2tree
parent2605a9e6f3bba5edf6616ca565170ab49b0811fecommit | diff
Lp 1922567: Limit authority.full_rec.value indexes

Limit the authority_full_rec_value_index and
authority_full_rec_value_tpo_index indexes to the first 1024
characters of a field or subfield in order to avoid database errors
when inserting or updating authorities with long fields.

Include release note and regression test.

Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Jennifer Weston <jennifer.weston@equinoxOLI.org>
Signed-off-by: Galen Charlton <gmc@equinoxOLI.org>
Open-ILS/src/sql/Pg/011.schema.authority.sql diff | blob | history
Open-ILS/src/sql/Pg/t/regress/lp1922567-test-asset-full-rec-indexes.pg [new file with mode: 0644] blob
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.authority-full-rec-value-index.sql [new file with mode: 0644] blob
docs/RELEASE_NOTES_NEXT/Cataloging/authority-full-rec-value-index.adoc [new file with mode: 0644] blob
Evergreen ILS