LP#1564079 Checkout history skips nonexistent items
authorBill Erickson <berickxx@gmail.com>
Wed, 30 Mar 2016 21:57:59 +0000 (17:57 -0400)
committerBill Erickson <berickxx@gmail.com>
Thu, 21 Mar 2019 19:46:23 +0000 (15:46 -0400)
commit2331951cf962ccfe6e9026be88352bd1c2f840f3
tree1c59c9ee3009e0253dfb3ab49b12032b837091a3
parent46c1c70474dbd0642e3a97a4234c343aee930ddb
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>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
Open-ILS/src/sql/Pg/upgrade/0960.schema.decouple_co_history.sql