db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-4681) Dropping a column in the table drops the views that use this table
Date Fri, 19 Oct 2012 13:40:12 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13480020#comment-13480020
] 

Rick Hillegas commented on DERBY-4681:
--------------------------------------

Thanks for your interest in this issue, Karl. Two useful places to start would be:

1) Take a look at the javadoc for DependencyManager. The DependencyManager is responsible
for tracking the dependencies among schema objects and statements.

2) Take a look at the stack trace for the error raised by the RESTRICTed drop in the repro
above:

create table t2( a int, b int );
create view v4( b ) as select b from t2;
--
-- View v4 should not be dropped because it does
-- not mention the deprecated column.
-- 
alter table t2 drop column a restrict; 

That stack trace will take you to the place in ViewDescriptor where the error is raised and
give you a beachhead into Derby's dependency management.

Thanks,
-Rick
                
> Dropping a column in the table drops the views that use this table
> ------------------------------------------------------------------
>
>                 Key: DERBY-4681
>                 URL: https://issues.apache.org/jira/browse/DERBY-4681
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0,
10.5.3.0, 10.6.1.0
>         Environment: Windows 7 Enterprise, JDK SE 1.6 u20
>            Reporter: Grzegorz Łyp
>            Priority: Critical
>              Labels: derby_triage10_8
>
> If i have a table and a view that uses this table, after dropping a column from this
table the whole view is also dropped.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message