[
https://issues.apache.org/jira/browse/DERBY-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13196180#comment-13196180
]
Dag H. Wanvik commented on DERBY-5591:
--------------------------------------
Btw, the view will get dropped if privileges to objects it depends on are
revoked, too, cf REVOKE statement doc,
http://db.apache.org/derby/docs/10.8/ref/rrefsqljrevoke.html.
Of course, REVOKE isn't strictly "dropping", but DROP ROLE will lead to
privilege revocation, so DROP ROLE is another example negating the sentence in
question.
> 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
> Reporter: Dag H. Wanvik
> 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
