[jira] [Updated] (DERBY-5591) Imprecise wording in documentation in ref man on DROP VIEW
[ https://issues.apache.org/jira/browse/DERBY-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase updated DERBY-5591: - Attachment: rrefsqlj61102.html DERBY-5591.diff Attaching DERBY-5591.diff and rrefsqlj61102.html, with modifications to the DROP VIEW topic. M src/ref/rrefsqlj61102.dita Hope this captures the situation -- further edits are welcome. > 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: DERBY-5591.diff, repro.sh, rrefsqlj61102.html > > > 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
[jira] [Updated] (DERBY-5591) Imprecise wording in documentation in ref man on DROP VIEW
[ https://issues.apache.org/jira/browse/DERBY-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase updated DERBY-5591: - Issue & fix info: Patch Available > 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: DERBY-5591.diff, repro.sh, rrefsqlj61102.html > > > 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
[jira] [Updated] (DERBY-5591) Imprecise wording in documentation in ref man on DROP VIEW
[ https://issues.apache.org/jira/browse/DERBY-5591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dag H. Wanvik updated DERBY-5591: - Attachment: repro.sh > 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
