[DERBY-5794] COMPOUND TRIGGER SUPPORT

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.8.1.2
• Component/s: SQL
• Labels: compound derby_triage10_10 performance simplex trigger
• Urgency: Normal
• Bug behavior facts: Performance
• Assignee: Unassigned
• Reporter: Chirag Mehta
• Created: 30/May/12 20:08
• Updated: 16/Oct/15 17:37

Description

I tried to search the for support of Compound Triggers like Oracle, didn't found any support in Derby 10.8 may be this would be a good functionality we can support. I really like using derby, this is my first project where I start using derby as an interim database for developers. We have oracle in production. So if we have compund trigger support with derby it would be grt.

Write now as workaround I am creating 3 triggers (After insert, update and delete) in derby and 1 in oracle.

If we have compound trigger it would increase the performance also.

Thanks a ton team for your work