LP#1920826: ensure that some DB updates missed in 3.6.0 are included
authorGalen Charlton <gmc@equinoxOLI.org>
Fri, 31 Mar 2023 22:11:36 +0000 (18:11 -0400)
committerChris Sharp <csharp@georgialibraries.org>
Tue, 9 May 2023 15:01:04 +0000 (11:01 -0400)
commit101245847a6a02b7771278d96ea76c9f17dcd251
treecc79478f5d85d9c1023a0c015179b0aa96a5d6b5
parent9d7dea881d8a14c1a7e66ac805723329b462fb65
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>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.catch-up-on-missing-dbrevs-from-3-6-0.sql [new file with mode: 0644]