Derby
  1. Derby
  2. DERBY-4573

Reference manual is unclear about the purpose of REFERENCEDCOLUMNS in SYSTRIGGERS table.

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.3.0
    • Fix Version/s: 10.8.1.2
    • Component/s: Documentation
    • Labels:
      None

      Description

      The Reference manual (applies to all the releases) says following for REFERENCEDCOLUMNS in SYSTRIGGERS system table
      "descriptor of the columns referenced by UPDATE triggers".

      This is confusing because it does not indicate whether the columns referenced by the triggering statement or the columns referenced by the trigger action. My suggestion is as follows but please feel free to reword it if required.
      "descriptor of columns on which UPDATE trigger has been defined"

      1. rrefsistabs79888.html
        11 kB
        Kim Haase
      2. DERBY-4573-2.diff
        0.6 kB
        Kim Haase
      3. rrefsistabs79888.html
        11 kB
        Kim Haase
      4. DERBY-4573.diff
        0.6 kB
        Kim Haase

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12500234 ] Default workflow, editable Closed status [ 12800397 ]
          Rick Hillegas made changes -
          Fix Version/s 10.8.1.2 [ 12316362 ]
          Fix Version/s 10.8.1.1 [ 12316356 ]
          Rick Hillegas made changes -
          Fix Version/s 10.8.1.1 [ 12316356 ]
          Fix Version/s 10.8.1.0 [ 12315561 ]
          Kim Haase made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Kim Haase made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Issue & fix info [Patch Available]
          Fix Version/s 10.8.0.0 [ 12315561 ]
          Resolution Fixed [ 1 ]
          Kim Haase made changes -
          Attachment DERBY-4573-2.diff [ 12468299 ]
          Attachment rrefsistabs79888.html [ 12468300 ]
          Kim Haase made changes -
          Issue & fix info [Patch Available]
          Kim Haase made changes -
          Attachment DERBY-4573.diff [ 12468270 ]
          Attachment rrefsistabs79888.html [ 12468271 ]
          Kim Haase made changes -
          Assignee Kim Haase [ chaase3 ]
          Kim Haase made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-4691 [ DERBY-4691 ]
          Mamta A. Satoor created issue -

            People

            • Assignee:
              Kim Haase
              Reporter:
              Mamta A. Satoor
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development