[
https://issues.apache.org/jira/browse/DERBY-4573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12981474#action_12981474
]
Dag H. Wanvik commented on DERBY-4573:
--------------------------------------
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.
> Reference manual is unclear about the purpose of REFERENCEDCOLUMNS in
> SYSTRIGGERS table.
> ----------------------------------------------------------------------------------------
>
> Key: DERBY-4573
> URL: https://issues.apache.org/jira/browse/DERBY-4573
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.5.3.0
> Reporter: Mamta A. Satoor
> Assignee: Kim Haase
> Attachments: DERBY-4573.diff, rrefsistabs79888.html
>
>
> 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"
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
