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

Dag H. Wanvik commented on DERBY-5591:
--------------------------------------

This applies even if there are other permissions available that might
have saved the day (current impl limitation): as long as a dependency
on a specific permission is lost, the view dies.  Cf DERBY-1632.

But see also DERBY-1631 and DERBY-1782..



                
> 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
>         Attachments: repro.sh
>
>
> 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

        

Reply via email to