Скрипт check_up.sql

-- *********************************************************************
-- Name: check_up.sql
-- Purpose:
-- Author: Vladimir Begun
-- $Id$
-- TODO: XXX

PROMPT CHECK: The following three INSERT statements are Ok
INSERT INTO operation VALUES (1, &category_limit + 1);
INSERT INTO operation VALUES (2, &category_limit + 2);
INSERT INTO operation VALUES (3, &category_limit + 3);

PROMPT CHECK: This one violates foreign key constraint
INSERT INTO operation VALUES (4, &category_limit + 100);

PROMPT CHECK: This one violates category
INSERT INTO operation VALUES (5, &category_limit * 2 + 4);

PROMPT CHECK: This one violates category too
INSERT INTO account VALUES (1, &category_limit + 1);
COMMIT;