Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5591

Imprecise wording in documentation in ref man on DROP VIEW

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.8.2.2
    • 10.9.1.0
    • Documentation
    • 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?

      Attachments

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

        Issue Links

          Activity

            People

              chaase3 Camilla Haase
              dagw Dag H. Wanvik
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: