| Key: |
DERBY-14
|
| Type: |
Bug
|
| Status: |
Closed
|
| Resolution: |
Fixed
|
| Priority: |
Minor
|
| Assignee: |
Unassigned
|
| Reporter: |
Ramandeep Kaur
|
| Votes: |
0
|
| Watchers: |
0
|
|
If you were logged in you would be able to see more operations.
|
|
|
| Resolution Date: |
03/Nov/04 01:45 AM
|
|
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.
|
|
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. |
Show » |
| There are no subversion log entries for this issue yet.
|
|
Triggers do not evaluate functions in VALUES trigger actions.
