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

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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.5.3.0
    • 10.8.1.2
    • Documentation
    • 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. DERBY-4573.diff
          0.6 kB
          Camilla Haase
        2. DERBY-4573-2.diff
          0.6 kB
          Camilla Haase
        3. rrefsistabs79888.html
          11 kB
          Camilla Haase
        4. rrefsistabs79888.html
          11 kB
          Camilla Haase

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4691 The Reference Guide should say that SYSCOLPERMS.COLUMNS and SYSCOLUMNS.COLUMNDEFAULT are not part of Derby's public api

          • Major - Major loss of function.
          • Closed

          Activity

            People

              chaase3 Camilla Haase
              mamtas Mamta A. Satoor
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: