LP#1564079 Checkout history skips nonexistent items
authorBill Erickson <berickxx@gmail.com>
Wed, 30 Mar 2016 21:57:59 +0000 (17:57 -0400)
committerKathy Lussier <klussier@masslnc.org>
Wed, 27 Apr 2016 14:40:00 +0000 (10:40 -0400)
commit9a87f5241b722336ba194a9146fdd79a38474f91
treee0aea18959d9dcb4feff7d4ea35382185841a4c1
parent95def1984b4ccded97a0657e8196d4d4e95e96d7
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
Open-ILS/src/sql/Pg/version-upgrade/2.9.3-2.10.0-upgrade-db.sql