You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2014/09/17 13:22:34 UTC
[jira] [Commented] (DERBY-6417) Dropping a column in 10.7 release
when there is a trigger with REFERENCING OLD clause defined on the table
gives error "ERROR 42X05: Table/View 'OLD' does not exist.".
[ https://issues.apache.org/jira/browse/DERBY-6417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14137069#comment-14137069 ]
Knut Anders Hatlen commented on DERBY-6417:
-------------------------------------------
It looks like the problem was introduced with [the following commit|http://svn.apache.org/r1541167]:
------------------------------------------------------------------------
r1541167 | mamta | 2013-11-12 18:15:31 +0100 (Tue, 12 Nov 2013) | 5 lines
DERBY-6383(Update trigger defined on one column fires on update of other columns)
Backporting to 10.7
------------------------------------------------------------------------
> Dropping a column in 10.7 release when there is a trigger with REFERENCING OLD clause defined on the table gives error "ERROR 42X05: Table/View 'OLD' does not exist.".
> -----------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-6417
> URL: https://issues.apache.org/jira/browse/DERBY-6417
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.7.1.4
> Reporter: Mamta A. Satoor
> Fix For: 10.8.3.3, 10.9.2.2, 10.10.2.0, 10.11.1.2
>
>
> While working on DERBY-6383, wrote a junit test case to test the impact of DROP COLUMN on the triggers, found following incorrect behavior with 10.7 release. The behavior is correct on 10.8 and higher releases
> CREATE TABLE DERBY_6368_TAB1 (X INTEGER, Y INTEGER);
> CREATE TABLE DERBY_6368_TAB2 (X INTEGER, Y INTEGER);
> INSERT INTO DERBY_6368_TAB1 VALUES(1, 2);
> CREATE TRIGGER t3 AFTER UPDATE ON DERBY_6368_TAB1 REFERENCING old table AS old INSERT INTO DERBY_6368_TAB2 SELECT * FROM old;
> --1 row
> UPDATE DERBY_6368_TAB1 SET x = x + 1;
> select count(*) from DERBY_6368_TAB2;
> ALTER TABLE DERBY_6368_TAB1 DROP COLUMN Y;
> The ALTER TABLE above gives correct warning in 10.8 and higher as shown below
> WARNING 01502: The trigger T3 on table DERBY_6368_TAB1 has been dropped.
> but 10.7 gives following error
> ERROR 42X05: Table/View 'OLD' does not exist.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)