Trigger Tests¶

Functionality Tested¶

The tests should cover the following:

only schema based / only session based / both kind of triggers defined
trigger events: CREATE, DELETE, FIND, WRITE and ASSIGN
NEW BUFFER and OLD BUFFER in WRITE session-based triggers
ensure trigger is fired at the right time: when the buffer is released or the transaction ends (other cases)
triggers firing other triggers / how we avoid executing the same trigger in an infinite loop
the effect of return error/no-apply in database triggers
session based triggers
- scoping
- deregistration
- replacement