Derby
  1. Derby
  2. DERBY-1770

Make "mode db2sql" an optional phrase in the "create trigger" statement

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 10.0.2.2
    • Fix Version/s: 10.3.1.4
    • Component/s: SQL
    • Labels:
      None

      Description

      In order to declare a trigger, you have to include the phrase "mode db2sql". This phrase in non-ANSI--it does not turn up in the CREATE TRIGGER production from the ANSI spec, volume 2, section 11.39. It does turn up in the DB2 reference manual with the following explanation: "This clause is used to specify the mode of triggers. This is the only valid mode currently supported."

      This phrase should be made optional. This will strike a happy balance between our goals of supporting the ANSI syntax while still maintaining compatibility with previous versions of Derby.

        Issue Links

          Activity

          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Closed Closed
          76d 23m 1 Yip Ng 12/Nov/06 18:19
          Gavin made changes -
          Workflow jira [ 12382525 ] Default workflow, editable Closed status [ 12798116 ]
          Yip Ng made changes -
          Resolution Duplicate [ 3 ]
          Status Open [ 1 ] Closed [ 6 ]
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Hide
          Yip Ng added a comment -

          Fixed in DERBY-1953.

          Show
          Yip Ng added a comment - Fixed in DERBY-1953 .
          Bernt M. Johnsen made changes -
          Assignee Bernt M. Johnsen [ bernt ] Yip Ng [ yipng ]
          Hide
          Bernt M. Johnsen added a comment -

          Since this will be fixed by DERBY-1953 and Yip is assigned to that one.

          Show
          Bernt M. Johnsen added a comment - Since this will be fixed by DERBY-1953 and Yip is assigned to that one.
          Yip Ng made changes -
          Link This issue is part of DERBY-1953 [ DERBY-1953 ]
          Hide
          Yip Ng added a comment -

          DERBY-1953 also addresses this jira case.

          Show
          Yip Ng added a comment - DERBY-1953 also addresses this jira case.
          Bernt M. Johnsen made changes -
          Field Original Value New Value
          Assignee Bernt M. Johnsen [ bernt ]
          Rick Hillegas created issue -

            People

            • Assignee:
              Yip Ng
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development