[ http://issues.apache.org/jira/browse/DERBY-1539?page=comments#action_12424736 ] Mamta A. Satoor commented on DERBY-1539: ----------------------------------------
I am going to spend more time on your suggestion but from a quick look, I don't see any recompilation happening for triggers currently. Seems like triggers currently just ignore all the invalidations that come their way except for drop table/drop synonym etc. For these specific drop actions, triggers just raise an error that they are dependent on the object being dropped. But no recompilation seem to happen for any invalidation. Also, we would need recompilation mechanism for views and constraints too because they are also dependent on privileges and hence will be notified of revoke actions. Don't think there is any code for views and constraints to get recompiled. Will investigate into this more to be sure what happens if recompilation is required. > As per the functional spec attached to DERBY-1330, a trigger should be > dropped when a privilege required by the trigger is revoked. > ----------------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-1539 > URL: http://issues.apache.org/jira/browse/DERBY-1539 > Project: Derby > Issue Type: New Feature > Components: SQL > Affects Versions: 10.2.0.0 > Reporter: Mamta A. Satoor > Assigned To: Mamta A. Satoor > Fix For: 10.2.0.0 > > Attachments: DERBY1539V1hashCodeEqualsDiff.txt, > DERBY1539V1hashCodeEqualsStat.txt, DERBY1539V2diffDropTriggerOnRevoke.txt, > DERBY1539V2statDropTriggerOnRevoke.txt, > DERBY1539V3diffDropTriggerOnRevoke.txt, > DERBY1539V3statDropTriggerOnRevoke.txt, > DERBY1539V4diffDropTriggerOnRevoke.txt, > DERBY1539V4diffDropTriggerOnRevokeRequiredPrivilege.txt, > DERBY1539V4statDropTriggerOnRevokeRequiredPrivilege.txt > > > A trigger tracks its privileges requirements using Derby's Dependency > Manager. If any one of those required privileges are revoked, the trigger > should be dropped automatically. > I am just creating a new jira entry here so it is easier to track sub items > of DERBY-1330. Will link this Jira entry to DERBY-1330. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
