[
https://issues.apache.org/jira/browse/DERBY-3940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kristian Waagan updated DERBY-3940:
-----------------------------------
Issue & fix info: [Known fix, Repro attached, Workaround attached]
Urgency: Normal
Triaged July 3, 2009: Assigned normal urgency, marked as Known fix, Repro
attached and Workaround attached.
> Dropping a column does not drop triggers which mention that column
> ------------------------------------------------------------------
>
> Key: DERBY-3940
> URL: https://issues.apache.org/jira/browse/DERBY-3940
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.4.2.1, 10.5.1.1
> Reporter: Rick Hillegas
> Attachments: dropColumnWithTrigger.sql, Triggers.java
>
>
> Put an INSERT trigger on a table and mention a column in the trigger. Then
> drop that column from the table. If you drop the column with RESTRICT
> semantics, you don't get an objection. Both CASCADE and RESTRICT drop the
> column. However, the trigger remains in both cases. After that, INSERTs into
> the table fail because the trigger can't find the dropped column. The
> workaround is to manually drop the trigger either before or after dropping
> the column. I will attach a test case.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
