Derby
  1. Derby
  2. DERBY-5591

Imprecise wording in documentation in ref man on DROP VIEW

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.8.2.2
    • Fix Version/s: 10.9.1.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      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?

      1. rrefsqlj61102.html
        5 kB
        Kim Haase
      2. repro.sh
        0.8 kB
        Dag H. Wanvik
      3. DERBY-5591.diff
        1 kB
        Kim Haase

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12651096 ] Default workflow, editable Closed status [ 12796687 ]
          Kim Haase made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Kim Haase made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Issue & fix info Patch Available [ 10102 ]
          Fix Version/s 10.9.0.0 [ 12316344 ]
          Resolution Fixed [ 1 ]
          Kim Haase made changes -
          Issue & fix info Patch Available [ 10102 ]
          Kim Haase made changes -
          Attachment DERBY-5591.diff [ 12527503 ]
          Attachment rrefsqlj61102.html [ 12527504 ]
          Dag H. Wanvik made changes -
          Attachment repro.sh [ 12526543 ]
          Kathey Marsden made changes -
          Affects Version/s 10.8.2.2 [ 12317968 ]
          Kim Haase made changes -
          Assignee Kim Haase [ chaase3 ]
          Dag H. Wanvik made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-5567 [ DERBY-5567 ]
          Dag H. Wanvik created issue -

            People

            • Assignee:
              Kim Haase
              Reporter:
              Dag H. Wanvik
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development