[ http://issues.apache.org/jira/browse/DERBY-115?page=all ]
Jeff Levitt updated DERBY-115:
------------------------------
Attachment: derby115.zip
Attached patch fixes the syntax, adds NO CASCADE BEFORE, and mentions Before
triggers in two additional places in the topic where it used to just mention
After triggers. Please see attached output in html for review, and provide
either feedback or a thumbs up so we can get the changes commited. Thanks!
> BEFORE triggers missing from CREATE TRIGGER documentation
> ---------------------------------------------------------
>
> Key: DERBY-115
> URL: http://issues.apache.org/jira/browse/DERBY-115
> Project: Derby
> Type: Bug
> Components: Documentation
> Versions: 10.0.2.1
> Reporter: Daniel John Debrunner
> Priority: Minor
> Attachments: derby115.zip
>
> Derby does support before triggers, syntax is the same as after triggers,
> but replace AFTER with NO CASCADE BEFORE. Eg.
> create trigger t1
> NO CASCADE BEFORE insert on x
> referencing new_table as newrowtab
> for each statement mode db2sql
> insert into y select x from newrowtab;
--
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
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
