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

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.

> 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:,,,,,,,,
>         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

View raw message