LP#1676608: copy alert and suppression matrix
[working/Evergreen.git] / Open-ILS / src / sql / Pg / live_t / copy_state.pg
1 BEGIN;
2
3 SELECT plan(1);
4
5 \set copy_id 245
6
7 UPDATE asset.copy SET status = 4 WHERE id = :copy_id;
8
9 SELECT is(asset.copy_state(:copy_id), 'MISSING', 'asset.copy_state detects missing state');
10
11 ROLLBACK;