LP#1920826: ensure that some DB updates missed in 3.6.0 are included user/gmcharlt/catch-up-on-3.6.0ish-dbrevs
authorGalen Charlton <gmc@equinoxOLI.org>
Fri, 31 Mar 2023 22:11:36 +0000 (18:11 -0400)
committerGalen Charlton <gmc@equinoxOLI.org>
Fri, 31 Mar 2023 22:18:56 +0000 (18:18 -0400)
commit3d83ecd9a2d0af1ab51a0f3885e7a2daf11fb3f9
tree2279fc62d025b69fe5ef7458624f2a0850cbdd81
parentd188f059b754a450942aecc3545af1f630fd866c
LP#1920826: ensure that some DB updates missed in 3.6.0 are included

This patch fixes a situation where an Evergreen database that had
been been upgraded to 3.6.0 at some point in its past using the
3.5.1-3.6.0 DB update script may be missing some DB revisions.

To test
-------
[1] Locate a test database that had been upgraded to 3.6.0 at some point
    and is missing some or all of DB revisions 1236-1240.
[2] Run the DB update in this patch.
[3] Verify that the DB revisions are in place and that the following
    bugs are resolved:

    - https://bugs.launchpad.net/evergreen/+bug/1788260 (1236)
    - https://bugs.launchpad.net/evergreen/+bug/1908727 (1237)
    - https://bugs.launchpad.net/evergreen/+bug/1835127 (1238)
    - https://bugs.launchpad.net/evergreen/+bug/1910891 (also 1238)
    - https://bugs.launchpad.net/evergreen/+bug/1882825 (1239)
    - https://bugs.launchpad.net/evergreen/+bug/1096209 (1240)

Signed-off-by: Galen Charlton <gmc@equinoxOLI.org>
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.catch-up-on-missing-dbrevs-from-3-6-0.sql [new file with mode: 0644]