db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <j...@apache.org>
Subject [jira] Issue Comment Edited: (DERBY-4538) If the CREATE TRIGGER does not have the REFERENCING clause, then there is no need to keep before and after values for the triggering table
Date Tue, 02 Mar 2010 00:28:05 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12839933#action_12839933
] 

Mamta A. Satoor edited comment on DERBY-4538 at 3/2/10 12:27 AM:
-----------------------------------------------------------------

Knut, thanks for reviwing the patch. I committed the changes(with revision 917771) after removing
the redundant ;

Will go ahead and close this issue. 

      was (Author: mamtas):
    Knut, thanks for reviwing the patch. I committed the chnages after removing the redundant
;

I will go ahead and close this issue. 
  
> If the CREATE TRIGGER does not have the REFERENCING clause, then there is no need to
keep before and after values for the triggering table
> ------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4538
>                 URL: https://issues.apache.org/jira/browse/DERBY-4538
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.6.0.0
>            Reporter: Mamta A. Satoor
>            Assignee: Mamta A. Satoor
>            Priority: Minor
>         Attachments: DERBY4538_NoReferencingClause_diff_v1.txt, DERBY4538_NoReferencingClause_diff_v2.txt,
DERBY4538_NoReferencingClause_stat_v1.txt, DERBY4538_NoReferencingClause_stat_v2.txt
>
>
> In order for the trigger action to have access to before and after values of the triggering
table, the CREATE TRIGGER should use the REFERENCING clause. Without the REFERENCING clause,
old and new values of triggering table can't be accessed by the trigger action. Based on this,
we can improve Derby memory utilization by not keeping old and new values if REFERENCING clause
is missing. It will be good to see if the code already does this optimization and if not,
then introducing this optimization will definitely be very useful when the triggering table
could have LOB columns.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message