[
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
