Lines Matching refs:RAISE
13 # This file tests the RAISE() function.
25 WHEN (new.a = 4) THEN RAISE(IGNORE) END;
29 WHEN (new.a = 1) THEN RAISE(ABORT, 'Trigger abort')
30 WHEN (new.a = 2) THEN RAISE(FAIL, 'Trigger fail')
31 WHEN (new.a = 3) THEN RAISE(ROLLBACK, 'Trigger rollback') END;
94 # Check that we can also do RAISE(IGNORE) for UPDATE and DELETE
101 SELECT CASE WHEN (old.a = 1) THEN RAISE(IGNORE) END;
105 SELECT CASE WHEN (old.a = 1) THEN RAISE(IGNORE) END;
121 # Check that RAISE(IGNORE) works correctly for nested triggers:
141 SELECT CASE WHEN (new.a = 1) THEN RAISE(ROLLBACK, 'View rollback')
142 WHEN (new.a = 2) THEN RAISE(IGNORE)
143 WHEN (new.a = 3) THEN RAISE(ABORT, 'View abort') END;