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

          Hide
          Yip Ng added a comment -

          Fixed in DERBY-1953.

          Show
          Yip Ng added a comment - Fixed in DERBY-1953 .
          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.
          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.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development