[DERBY-14] Triggers do not evaluate functions in VALUES trigger actions.

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.0.2.0
• Fix Version/s: 10.0.2.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Ramandeep Kaur
• Created: 29/Sep/04 18:54
• Updated: 07/Jun/05 00:23
• Resolved: 03/Nov/04 01:45

Description

Opening this bug on behalf of Jack Klebanoff.

---------------------------------------------------------
If a trigger is created with

CREATE TRIGGER T ... VALUES( fn())

The function fn is not called even if the trigger event
happens. Side effects of the function will not happen.

Derby does not allow CALL statements in trigger actions.
In Derby, one has to use a VALUES statement and depend on function side effects.