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:50:51 +0000 (10:50 -0400)
commit53b34b33c98ad5a195f4180b70803cc2f2a25aa1
treeadf89608d95852d579cc21ca084ecb6c29ee62c1
parent705029f0003041bd7b7fc450861ddd7fc85c8dca
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
Open-ILS/src/sql/Pg/t/regress/lp1922567-test-asset-full-rec-indexes.pg [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.authority-full-rec-value-index.sql [new file with mode: 0644]
docs/RELEASE_NOTES_NEXT/Cataloging/authority-full-rec-value-index.adoc [new file with mode: 0644]