LP#1564079 Checkout history skips nonexistent items user/berick/lp1564079-circ-history-serials-deleted
authorBill Erickson <berickxx@gmail.com>
Wed, 30 Mar 2016 21:57:59 +0000 (17:57 -0400)
committerBill Erickson <berickxx@gmail.com>
Wed, 30 Mar 2016 21:58:01 +0000 (17:58 -0400)
commit8497f23a3934a9fd29fa1d15e5d6a80a8f990c96
tree0e1f1a5858a7d7321e73331881fa767dccdb9a49
parenta3434fc89779d731c71f0bcc468c2d560a5c5ee4
LP#1564079 Checkout history skips nonexistent items

Modify the user checkout history migration process
(2.9.3-2.10.0-upgrade-db.sql and 0960.schema.decouple_co_history.sql) to
avoid inserting history rows for circulations whose copies do not
exist in the database.

For reference, this is a rare condition that cannot be recreated in a
modern EG system short of modifying constraints.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Open-ILS/src/sql/Pg/upgrade/0960.schema.decouple_co_history.sql
Open-ILS/src/sql/Pg/version-upgrade/2.9.3-2.10.0-upgrade-db.sql