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

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

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: 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"

        Attachments

        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

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: