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. DERBY-4573.diff
        0.6 kB
        Kim Haase
      2. DERBY-4573-2.diff
        0.6 kB
        Kim Haase
      3. rrefsistabs79888.html
        11 kB
        Kim Haase
      4. rrefsistabs79888.html
        11 kB
        Kim Haase

        Issue Links

          Activity

          Mamta A. Satoor created issue -
          Kim Haase made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-4691 [ DERBY-4691 ]
          Hide
          Kim Haase added a comment -

          If/when I file a second patch for DERBY-4691, I should fix this too.

          Show
          Kim Haase added a comment - If/when I file a second patch for DERBY-4691 , I should fix this too.
          Kim Haase made changes -
          Assignee Kim Haase [ chaase3 ]
          Hide
          Kim Haase added a comment -

          Attaching DERBY-4573.diff and the modified rrefsistabs79888.html topic.

          I wasn't sure whether to say

          "Descriptor of the columns on which an UPDATE trigger has been defined"

          or

          "Descriptor of the columns on which UPDATE triggers have been defined"

          I think they both mean the same thing, essentially. I went with the first one. Hope that's okay.

          Show
          Kim Haase added a comment - Attaching DERBY-4573 .diff and the modified rrefsistabs79888.html topic. I wasn't sure whether to say "Descriptor of the columns on which an UPDATE trigger has been defined" or "Descriptor of the columns on which UPDATE triggers have been defined" I think they both mean the same thing, essentially. I went with the first one. Hope that's okay.
          Kim Haase made changes -
          Attachment DERBY-4573.diff [ 12468270 ]
          Attachment rrefsistabs79888.html [ 12468271 ]
          Kim Haase made changes -
          Issue & fix info [Patch Available]
          Hide
          Dag H. Wanvik added a comment -

          Hi Kim, I think you made the right choice, since this information pertains to exactly one trigger (or none).

          Even more precise wording might perhaps be:

          If this trigger is an update trigger (i.e. the EVENT column contains 'U'), this is the descriptor of the columns to be updated.

          Show
          Dag H. Wanvik added a comment - Hi Kim, I think you made the right choice, since this information pertains to exactly one trigger (or none). Even more precise wording might perhaps be: If this trigger is an update trigger (i.e. the EVENT column contains 'U'), this is the descriptor of the columns to be updated.
          Hide
          Kim Haase added a comment -

          Thanks for that clarification, Dag! I'm attaching a revised patch, DERBY-4573-2.diff, and new version of the topic, with your change. I modified the word order to be consistent with the other items in that column of the table – hope that's okay.

          Show
          Kim Haase added a comment - Thanks for that clarification, Dag! I'm attaching a revised patch, DERBY-4573 -2.diff, and new version of the topic, with your change. I modified the word order to be consistent with the other items in that column of the table – hope that's okay.
          Kim Haase made changes -
          Attachment DERBY-4573-2.diff [ 12468299 ]
          Attachment rrefsistabs79888.html [ 12468300 ]
          Hide
          Kim Haase added a comment -

          In the absence of further comment, I'm assuming the revision is okay. Thanks again, Dag.

          Committed patch DERBY-4573-2.diff to documentation trunk at revision 1060404.

          Show
          Kim Haase added a comment - In the absence of further comment, I'm assuming the revision is okay. Thanks again, Dag. Committed patch DERBY-4573 -2.diff to documentation trunk at revision 1060404.
          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 ]
          Hide
          Kim Haase added a comment -

          Change has appeared in latest alpha docs, so closing.

          Show
          Kim Haase added a comment - Change has appeared in latest alpha docs, so closing.
          Kim Haase made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Rick Hillegas made changes -
          Fix Version/s 10.8.1.1 [ 12316356 ]
          Fix Version/s 10.8.1.0 [ 12315561 ]
          Rick Hillegas made changes -
          Fix Version/s 10.8.1.2 [ 12316362 ]
          Fix Version/s 10.8.1.1 [ 12316356 ]
          Gavin made changes -
          Workflow jira [ 12500234 ] Default workflow, editable Closed status [ 12800397 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Resolved Resolved
          326d 7h 58m 1 Kim Haase 18/Jan/11 15:06
          Resolved Resolved Closed Closed
          9d 3h 14m 1 Kim Haase 27/Jan/11 18:20

            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