Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-115

BEFORE triggers missing from CREATE TRIGGER documentation

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.0.2.1
    • 10.1.1.0
    • Documentation
    • None

    Description

      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;

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            djd Daniel John Debrunner
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment