[DERBY-3948] Don't allow references to generated columns in the NEW transition variables of triggered actions of BEFORE triggers

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.5.1.1
• Fix Version/s: 10.5.1.1
• Component/s: SQL
• Assignee: Richard N. Hillegas
• Reporter: Richard N. Hillegas
• Created: 14/Nov/08 20:41
• Updated: 30/Sep/13 09:00
• Resolved: 19/Nov/08 15:34

Description

Thanks to Dag for finding this restriction in the SQL Standard, part 2, section 11.39, SR 12 c) I see this provision:

12) If BEFORE is specified, then:
:
c) The <triggered action> shall not contain a <field reference> that
references a field in the new transition variable corresponding to a
generated column of T.

Issue Links

• is part of: DERBY-481 implement SQL generated columns