[DERBY-534] Support use of the WHEN clause in CREATE TRIGGER statements

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 10.11.1.1
• Component/s: SQL
• Labels: derby_triage10_11
• Urgency: Low
• Assignee: Knut Anders Hatlen
• Reporter: Kristian Waagan
• Created: 24/Aug/05 18:50
• Updated: 09/Sep/16 09:52
• Resolved: 19/Nov/13 12:27

Description

Support use of the WHEN clause in CREATE TRIGGER statements. The clause is described in the SQL standard (2003) in chapter "11.39 <trigger definition>" under "<triggered action>".

There are traces in the code that suggests some work has been done on this earlier. If anyone knows something about this, please add a comment to this issue.

Issue Links

• incorporates: DERBY-6390 Document the WHEN clause in the CREATE TRIGGER statement
• is related to: DERBY-6348 NPE or assert failure in recursive trigger
• is related to: DERBY-6357 CREATE TRIGGER doesn't detect all illegal references to SESSION schema
• is related to: DERBY-6783 WHEN clause in CREATE TRIGGER for UPDATE is not working for the sql script below
• is related to: DERBY-2041 Trigger should register a dependency on tables and columns used in its body