db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From derby-...@db.apache.org
Subject [jira] Created: (DERBY-14) Triggers do not evaluate functions in VALUES trigger actions.
Date Wed, 29 Sep 2004 18:56:32 GMT
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


Mime
View raw message