db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5591) Imprecise wording in documentation in ref man on DROP VIEW
Date Mon, 07 May 2012 20:58:52 GMT

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

Kim Haase commented on DERBY-5591:
----------------------------------

Would the following statements be more precise or am I misunderstanding this?

Normally, you must drop a view before you drop any objects that the view depends on. 

However, if you issue an ALTER TABLE DROP COLUMN command with the CASCADE option, any views
that depend on the column will be dropped. Also, if you use a REVOKE or DROP ROLE statement
to revoke privileges on objects that a view depends on, the view will be dropped.

                
> Imprecise wording in documentation in ref man on DROP VIEW
> ----------------------------------------------------------
>
>                 Key: DERBY-5591
>                 URL: https://issues.apache.org/jira/browse/DERBY-5591
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.8.2.2
>            Reporter: Dag H. Wanvik
>            Assignee: Kim Haase
>            Priority: Minor
>
> This sentence is misleading: "Any statements referencing the view are invalidated on
a DROP VIEW statement. DROP VIEW is disallowed if there are any views or open cursors dependent
on the view. The view must be dropped before any objects that it is dependent on can be dropped."

> This isn't quite true. If a column is dropped with the CASCADE option, any dependent
view(s) will be dropped. Are there other cases?

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message