projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 422971f) | patch
Lp 1922567: Limit authority.full_rec.value indexes user/dyrcona/lp1922567-long-authority-full-rec-values-fix
authorJason Stephenson <jason@sigio.com>
Tue, 6 Apr 2021 11:43:52 +0000 (07:43 -0400)
committerJason Stephenson <jason@sigio.com>
Tue, 6 Apr 2021 11:43:52 +0000 (07:43 -0400)
commit4b60d8d67d9754f1affe7a271ba7bd87b20adcc3
tree746e7f9f3e7218192efe51ce5a5e11108dcf006ftree
parent422971f7868151bec3aa703ef88af8b1d72679c0commit | 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>
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