LP2061136 - Stamping 1405 DB upgrade script

[working/Evergreen.git] / Open-ILS / src / sql / Pg / live_t / copy_state.pg

BEGIN;

SELECT plan(1);

\set copy_id 245

UPDATE asset.copy SET status = 4 WHERE id = :copy_id;

SELECT is(asset.copy_state(:copy_id), 'MISSING', 'asset.copy_state detects missing state');

ROLLBACK;