Message: A new issue has been created in JIRA.
--------------------------------------------------------------------- View the issue: http://issues.apache.org/jira/browse/DERBY-14 Here is an overview of the issue: --------------------------------------------------------------------- Key: DERBY-14 Summary: Triggers do not evaluate functions in VALUES trigger actions. Type: Bug Status: Unassigned Priority: Minor Project: Derby Components: SQL Versions: 10.0.2.0 Assignee: Reporter: Ramandeep Kaur Created: Wed, 29 Sep 2004 11:54 AM Updated: Wed, 29 Sep 2004 11:54 AM 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. --------------------------------------------------------------------- JIRA INFORMATION: This message is automatically generated by JIRA. If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
